| SQL Id | SQL Text |
|---|
| 02q27vmzu5jw5 | begin
-- Call the procedure
p_uat_extract.run(p_date_in => :p_date_in);
end;
|
| 072gpgmwzjs1c | SELECT STATEMENT_ITEM_ID, CREATED_BY, CREATED_ON, DERIVED_ITEM_AMOUNT, DERIVED_TAX_AMOUNT, DERIVED_TOTAL_AMOUNT, DESCRIPTION, LAST_UPDATED_BY, LAST_UPDATED_ON, MODIFIED, NAME, NOTES, PERIOD_END, PERIOD_START, QUANTITY, QUANTITY_OVERRIDE, RECORDED_TIMESTAMP, STATEMENT_ID, STATEMENT_ITEM_TEMPLATE_ID, STATEMENT_ITEM_TYPE, STATUS, TAX_CODE_ID, UNIT_PRICE, UNIT_PRICE_OVERRIDE FROM STATEMENT_ITEM WHERE (STATEMENT_ITEM_ID = :1) |
| 0k59w7w6q6khw |
SELECT V_ROWNUM, CONT_CONTRACT_CODE, CONT_CONTRACT_TEMPLATE_ID, CONT_CUSTOMER_ID, CONT_DESCRIPTION, CONT_NAME, CONT_PERIOD_END, CONT_PERIOD_START, CONT_REFERENCE_NUMBER, CONT_STATUS, CONT_TRANSACTION_ID, CONTRACT_ID, DAIT_CODE, DAIT_DATA_TYPE_ID, DAIT_DESC_TRANSLATION_ID, DAIT_DESCRIPTION, DAIT_DISPLAY_SEQUENCE, DAIT_FORMAT_MASK, DAIT_MULTIPLICITY, DAIT_NAME, DAIT_NAME_TRANSLATION_ID, DAIT_PERIOD_END, DAIT_PERIOD_START, DAIT_UOM_CODE, DATA_ITEM_TYPE_ID, ENTE_CODE, ENTE_CREATED_ON, ENTE_DATA_ITEM_TYPE_ID, ENTE_DESC_TRANSLATION_ID, ENTE_DESCRIPTION, ENTE_INSTANCE_TYPE_CODE, ENTE_NAME, ENTE_NAME_TRANSLATION_ID, ENTE_PERIOD_END, ENTE_PERIOD_START, ENTE_PERIOD_TEMPLATE_ID, ENTE_PROC_TEMP_TYPE_CODE, ENTE_SOURCE, ENTE_TIMELINE_PERIOD_TPL_ID, ENTE_TYPE, ENTE_VERSION, ENTITY_TEMPLATE_ID, NOMINATION_SCHED_PERIOD_ID, NOMINATION_SCHED_QUANTITY_ID, NOMINATION_SCHEDULE_ID, NOSC_CONTRACT_ID, NOSC_CREATED_FOR_TIMESTAMP, NOSC_ENTITY_TEMPLATE_ID, NOSC_NAME, NOSC_NOMINATION_SCHED_GROUP_ID, NOSC_RECORDED_TIMESTAMP, NOSC_SCHED_FOR_PERIOD_END, NOSC_SCHED_FOR_PERIOD_START, NOSC_SOURCE, NOSC_STATUS, NOSC_TRANSACTION_ID, NOSP_CUSTOMER_NOMINATION_ID, NOSP_NOMINATION_SCHEDULE_ID, NOSP_PERIOD_TEMPLATE_ID, NOSP_SCHEDULE_PERIOD_END, NOSP_SCHEDULE_PERIOD_QTY_TOTAL, NOSP_SCHEDULE_PERIOD_START, NOSP_STATUS, NOSP_TRANSACTION_ID, NOSQ_COMMENTS, NOSQ_COUNTER_PARTY, NOSQ_MODIFIED, NOSQ_QUANTITY, NOSQ_QUANTITY_TEMPLATE_ID, NOSQ_SERVICE_ID, NOSQ
_SOURCE, NOSQ_STATUS, NOSQ_TRANSACTION_ID, QUANTITY_TEMPLATE_ID, QUTE_CODE, QUTE_DATA_ITEM_TYPE_ID, QUTE_DESC_TRANSLATION_ID, QUTE_DESCRIPTION, QUTE_DISPLAY_SEQUENCE, QUTE_ENTERABLE, QUTE_FORMAT_MASK, QUTE_INSTANCE_TYPE_CODE, QUTE_NAME, QUTE_NAME_TRANSLATION_ID, QUTE_PERIOD_END, QUTE_PERIOD_START, QUTE_PRTT_CODE, QUTE_SERVICE_ID, QUTE_SOURCE, QUTE_TYPE, QUTE_VERSION, QUTE_VIEWABLE, SERV_CODE, SERV_DESC_TRANSLATION_ID, SERV_DESCRIPTION, SERV_NAME, SERV_NAME_TRANSLATION_ID, SERV_PERIOD_END, SERV_PERIOD_START, SERV_TRADABLE, SERV_TRANSFERABLE, SERV_TYPE, SERV_UOM_CODE, SERV_VERSION, SERVICE_ID FROM V_NOMINATION_SCHED_QUANTITY WHERE (((NOSQ_STATUS = :1) AND (CONTRACT_ID = :2)) AND (NOSP_SCHEDULE_PERIOD_START = :3)) |
| 0rjp0nk3sc1tn | SELECT DISPATCH_QUANTITY_EAV_ID, CREATED_BY, CREATED_ON, ENTITY_ATTRIBUTE_TYPE_ID, LAST_UPDATED_BY, LAST_UPDATED_ON, VALUE, DISPATCH_QUANTITY_ID FROM DISPATCH_QUANTITY_EAV WHERE (DISPATCH_QUANTITY_ID = :1) |
| 1wm6vm3xr9yv0 |
SELECT V_ROWNUM, CONT_CONTRACT_CODE, CONT_CONTRACT_TEMPLATE_ID, CONT_CUSTOMER_ID, CONT_DESCRIPTION, CONT_NAME, CONT_PERIOD_END, CONT_PERIOD_START, CONT_REFERENCE_NUMBER, CONT_STATUS, CONT_TRANSACTION_ID, CONTRACT_ID, DAIT_CODE, DAIT_DATA_TYPE_ID, DAIT_DESC_TRANSLATION_ID, DAIT_DESCRIPTION, DAIT_DISPLAY_SEQUENCE, DAIT_FORMAT_MASK, DAIT_MULTIPLICITY, DAIT_NAME, DAIT_NAME_TRANSLATION_ID, DAIT_PERIOD_END, DAIT_PERIOD_START, DAIT_UOM_CODE, DATA_ITEM_TYPE_ID, ENTE_CODE, ENTE_CREATED_ON, ENTE_DATA_ITEM_TYPE_ID, ENTE_DESC_TRANSLATION_ID, ENTE_DESCRIPTION, ENTE_INSTANCE_TYPE_CODE, ENTE_NAME, ENTE_NAME_TRANSLATION_ID, ENTE_PERIOD_END, ENTE_PERIOD_START, ENTE_PERIOD_TEMPLATE_ID, ENTE_PROC_TEMP_TYPE_CODE, ENTE_SOURCE, ENTE_TIMELINE_PERIOD_TPL_ID, ENTE_TYPE, ENTE_VERSION, ENTITY_TEMPLATE_ID, NOMINATION_SCHED_PERIOD_ID, NOMINATION_SCHED_QUANTITY_ID, NOMINATION_SCHEDULE_ID, NOSC_CONTRACT_ID, NOSC_CREATED_FOR_TIMESTAMP, NOSC_ENTITY_TEMPLATE_ID, NOSC_NAME, NOSC_NOMINATION_SCHED_GROUP_ID, NOSC_RECORDED_TIMESTAMP, NOSC_SCHED_FOR_PERIOD_END, NOSC_SCHED_FOR_PERIOD_START, NOSC_SOURCE, NOSC_STATUS, NOSC_TRANSACTION_ID, NOSP_CUSTOMER_NOMINATION_ID, NOSP_NOMINATION_SCHEDULE_ID, NOSP_PERIOD_TEMPLATE_ID, NOSP_SCHEDULE_PERIOD_END, NOSP_SCHEDULE_PERIOD_QTY_TOTAL, NOSP_SCHEDULE_PERIOD_START, NOSP_STATUS, NOSP_TRANSACTION_ID, NOSQ_COMMENTS, NOSQ_COUNTER_PARTY, NOSQ_MODIFIED, NOSQ_QUANTITY, NOSQ_QUANTITY_TEMPLATE_ID, NOSQ_SERVICE_ID, NOSQ
_SOURCE, NOSQ_STATUS, NOSQ_TRANSACTION_ID, QUANTITY_TEMPLATE_ID, QUTE_CODE, QUTE_DATA_ITEM_TYPE_ID, QUTE_DESC_TRANSLATION_ID, QUTE_DESCRIPTION, QUTE_DISPLAY_SEQUENCE, QUTE_ENTERABLE, QUTE_FORMAT_MASK, QUTE_INSTANCE_TYPE_CODE, QUTE_NAME, QUTE_NAME_TRANSLATION_ID, QUTE_PERIOD_END, QUTE_PERIOD_START, QUTE_PRTT_CODE, QUTE_SERVICE_ID, QUTE_SOURCE, QUTE_TYPE, QUTE_VERSION, QUTE_VIEWABLE, SERV_CODE, SERV_DESC_TRANSLATION_ID, SERV_DESCRIPTION, SERV_NAME, SERV_NAME_TRANSLATION_ID, SERV_PERIOD_END, SERV_PERIOD_START, SERV_TRADABLE, SERV_TRANSFERABLE, SERV_TYPE, SERV_UOM_CODE, SERV_VERSION, SERVICE_ID FROM V_NOMINATION_SCHED_QUANTITY WHERE (NOMINATION_SCHEDULE_ID = :1) |
| 20frb3fpdavaf |
SELECT V_ROWNUM, CONT_CONTRACT_CODE, CONT_CONTRACT_TEMPLATE_ID, CONT_CUSTOMER_ID, CONT_DESCRIPTION, CONT_NAME, CONT_PERIOD_END, CONT_PERIOD_START, CONT_REFERENCE_NUMBER, CONT_STATUS, CONT_TRANSACTION_ID, CONTRACT_ID, DAIT_CODE, DAIT_DATA_TYPE_ID, DAIT_DESC_TRANSLATION_ID, DAIT_DESCRIPTION, DAIT_DISPLAY_SEQUENCE, DAIT_FORMAT_MASK, DAIT_MULTIPLICITY, DAIT_NAME, DAIT_NAME_TRANSLATION_ID, DAIT_PERIOD_END, DAIT_PERIOD_START, DAIT_UOM_CODE, DATA_ITEM_TYPE_ID, ENTE_CODE, ENTE_CREATED_ON, ENTE_DATA_ITEM_TYPE_ID, ENTE_DESC_TRANSLATION_ID, ENTE_DESCRIPTION, ENTE_INSTANCE_TYPE_CODE, ENTE_NAME, ENTE_NAME_TRANSLATION_ID, ENTE_PERIOD_END, ENTE_PERIOD_START, ENTE_PERIOD_TEMPLATE_ID, ENTE_PROC_TEMP_TYPE_CODE, ENTE_SOURCE, ENTE_TIMELINE_PERIOD_TPL_ID, ENTE_TYPE, ENTE_VERSION, ENTITY_TEMPLATE_ID, NOMINATION_SCHED_PERIOD_ID, NOMINATION_SCHED_QUANTITY_ID, NOMINATION_SCHEDULE_ID, NOSC_CONTRACT_ID, NOSC_CREATED_FOR_TIMESTAMP, NOSC_ENTITY_TEMPLATE_ID, NOSC_NAME, NOSC_NOMINATION_SCHED_GROUP_ID, NOSC_RECORDED_TIMESTAMP, NOSC_SCHED_FOR_PERIOD_END, NOSC_SCHED_FOR_PERIOD_START, NOSC_SOURCE, NOSC_STATUS, NOSC_TRANSACTION_ID, NOSP_CUSTOMER_NOMINATION_ID, NOSP_NOMINATION_SCHEDULE_ID, NOSP_PERIOD_TEMPLATE_ID, NOSP_SCHEDULE_PERIOD_END, NOSP_SCHEDULE_PERIOD_QTY_TOTAL, NOSP_SCHEDULE_PERIOD_START, NOSP_STATUS, NOSP_TRANSACTION_ID, NOSQ_COMMENTS, NOSQ_COUNTER_PARTY, NOSQ_MODIFIED, NOSQ_QUANTITY, NOSQ_QUANTITY_TEMPLATE_ID, NOSQ_SERVICE_ID, NOSQ
_SOURCE, NOSQ_STATUS, NOSQ_TRANSACTION_ID, QUANTITY_TEMPLATE_ID, QUTE_CODE, QUTE_DATA_ITEM_TYPE_ID, QUTE_DESC_TRANSLATION_ID, QUTE_DESCRIPTION, QUTE_DISPLAY_SEQUENCE, QUTE_ENTERABLE, QUTE_FORMAT_MASK, QUTE_INSTANCE_TYPE_CODE, QUTE_NAME, QUTE_NAME_TRANSLATION_ID, QUTE_PERIOD_END, QUTE_PERIOD_START, QUTE_PRTT_CODE, QUTE_SERVICE_ID, QUTE_SOURCE, QUTE_TYPE, QUTE_VERSION, QUTE_VIEWABLE, SERV_CODE, SERV_DESC_TRANSLATION_ID, SERV_DESCRIPTION, SERV_NAME, SERV_NAME_TRANSLATION_ID, SERV_PERIOD_END, SERV_PERIOD_START, SERV_TRADABLE, SERV_TRANSFERABLE, SERV_TYPE, SERV_UOM_CODE, SERV_VERSION, SERVICE_ID FROM V_NOMINATION_SCHED_QUANTITY WHERE (((NOSC_STATUS = :1) AND (ENTE_CODE = :2)) AND (NOSC_SCHED_FOR_PERIOD_START = :3)) ORDER BY NOSP_SCHEDULE_PERIOD_START ASC |
| 4g6bwz9h9zgnr | SELECT * FROM V_USER_CONTEXT WHERE lower(USERNAME) = lower(:1) |
| 4hpbfdsrfchsk |
SELECT V_ROWNUM, CONT_CONTRACT_CODE, CONT_CONTRACT_TEMPLATE_ID, CONT_CUSTOMER_ID, CONT_DESCRIPTION, CONT_NAME, CONT_PERIOD_END, CONT_PERIOD_START, CONT_REFERENCE_NUMBER, CONT_STATUS, CONT_TRANSACTION_ID, CONTRACT_ID, DAIT_CODE, DAIT_DATA_TYPE_ID, DAIT_DESC_TRANSLATION_ID, DAIT_DESCRIPTION, DAIT_DISPLAY_SEQUENCE, DAIT_FORMAT_MASK, DAIT_MULTIPLICITY, DAIT_NAME, DAIT_NAME_TRANSLATION_ID, DAIT_PERIOD_END, DAIT_PERIOD_START, DAIT_UOM_CODE, DATA_ITEM_TYPE_ID, ENTE_CODE, ENTE_CREATED_ON, ENTE_DATA_ITEM_TYPE_ID, ENTE_DESC_TRANSLATION_ID, ENTE_DESCRIPTION, ENTE_INSTANCE_TYPE_CODE, ENTE_NAME, ENTE_NAME_TRANSLATION_ID, ENTE_PERIOD_END, ENTE_PERIOD_START, ENTE_PERIOD_TEMPLATE_ID, ENTE_PROC_TEMP_TYPE_CODE, ENTE_SOURCE, ENTE_TIMELINE_PERIOD_TPL_ID, ENTE_TYPE, ENTE_VERSION, ENTITY_TEMPLATE_ID, NOMINATION_SCHED_PERIOD_ID, NOMINATION_SCHED_QUANTITY_ID, NOMINATION_SCHEDULE_ID, NOSC_CONTRACT_ID, NOSC_CREATED_FOR_TIMESTAMP, NOSC_ENTITY_TEMPLATE_ID, NOSC_NAME, NOSC_NOMINATION_SCHED_GROUP_ID, NOSC_RECORDED_TIMESTAMP, NOSC_SCHED_FOR_PERIOD_END, NOSC_SCHED_FOR_PERIOD_START, NOSC_SOURCE, NOSC_STATUS, NOSC_TRANSACTION_ID, NOSP_CUSTOMER_NOMINATION_ID, NOSP_NOMINATION_SCHEDULE_ID, NOSP_PERIOD_TEMPLATE_ID, NOSP_SCHEDULE_PERIOD_END, NOSP_SCHEDULE_PERIOD_QTY_TOTAL, NOSP_SCHEDULE_PERIOD_START, NOSP_STATUS, NOSP_TRANSACTION_ID, NOSQ_COMMENTS, NOSQ_COUNTER_PARTY, NOSQ_MODIFIED, NOSQ_QUANTITY, NOSQ_QUANTITY_TEMPLATE_ID, NOSQ_SERVICE_ID, NOSQ
_SOURCE, NOSQ_STATUS, NOSQ_TRANSACTION_ID, QUANTITY_TEMPLATE_ID, QUTE_CODE, QUTE_DATA_ITEM_TYPE_ID, QUTE_DESC_TRANSLATION_ID, QUTE_DESCRIPTION, QUTE_DISPLAY_SEQUENCE, QUTE_ENTERABLE, QUTE_FORMAT_MASK, QUTE_INSTANCE_TYPE_CODE, QUTE_NAME, QUTE_NAME_TRANSLATION_ID, QUTE_PERIOD_END, QUTE_PERIOD_START, QUTE_PRTT_CODE, QUTE_SERVICE_ID, QUTE_SOURCE, QUTE_TYPE, QUTE_VERSION, QUTE_VIEWABLE, SERV_CODE, SERV_DESC_TRANSLATION_ID, SERV_DESCRIPTION, SERV_NAME, SERV_NAME_TRANSLATION_ID, SERV_PERIOD_END, SERV_PERIOD_START, SERV_TRADABLE, SERV_TRANSFERABLE, SERV_TYPE, SERV_UOM_CODE, SERV_VERSION, SERVICE_ID FROM V_NOMINATION_SCHED_QUANTITY WHERE (NOMINATION_SCHEDULE_ID = :1) ORDER BY NOSP_SCHEDULE_PERIOD_START ASC, QUTE_NAME ASC, NOSQ_STATUS ASC, NOSQ_COUNTER_PARTY ASC, SERV_NAME ASC |
| 4n7q8rrdynj5x |
SELECT V_ROWNUM, BCUOM_CODE, BCUOM_DESC_TRANSLATION_ID, BCUOM_DESCRIPTION, BCUOM_NAME, BCUOM_NAME_TRANSLATION_ID, BCUOM_UNIT_OF_MEASURE_ID, BCUOM_UNIT_OF_MEASURE_TYPE, BILLING_RUN_ID, CONTRACT_ID, CUSTOMER_ID, DAIT_CODE, DAIT_DATA_TYPE_ID, DAIT_DESC_TRANSLATION_ID, DAIT_DESCRIPTION, DAIT_DISPLAY_SEQUENCE, DAIT_FORMAT_MASK, DAIT_MULTIPLICITY, DAIT_NAME, DAIT_NAME_TRANSLATION_ID, DAIT_PERIOD_END, DAIT_PERIOD_START, DAIT_UOM_CODE, DATA_ITEM_TYPE_ID, PARENT_FINANCIAL_STATEMENT_ID, STAT_DERIVED_GRAND_TOTAL, STAT_DERIVED_SUB_TOTAL, STAT_DERIVED_TAX_AMOUNT, STAT_DESCRIPTION, STAT_EXTERNAL_IDENTIFIER, STAT_ISSUE_DATE, STAT_MODIFIED, STAT_NAME, STAT_NOTES, STAT_PAYMENT_DUE_DATE, STAT_PAYMENT_TERMS, STAT_PERIOD_END, STAT_PERIOD_START, STAT_RECORDED_TIMESTAMP, STAT_STATEMENT_REFERENCE, STAT_STATEMENT_TEMPLATE_ID, STAT_STATEMENT_TYPE, STAT_STATUS, STATEMENT_ID, STATEMENT_ITEM_ID, STATEMENT_ITEM_TEMPLATE_ID, STATEMENT_TEMPLATE_ID, STATEMENT_TPL_ITEM_TPL_MAP_ID, STIT_DERIVED_ITEM_AMOUNT, STIT_DERIVED_TAX_AMOUNT, STIT_DERIVED_TOTAL_AMOUNT, STIT_DESCRIPTION, STIT_MODIFIED, STIT_NAME, STIT_NOTES, STIT_PERIOD_END, STIT_PERIOD_START, STIT_QUANTITY, STIT_QUANTITY_OVERRIDE, STIT_RECORDED_TIMESTAMP, STIT_STAT_ITEM_TEMP_ID, STIT_STATEMENT_ID, STIT_STATEMENT_ITEM_TYPE, STIT_STATUS, STIT_UNIT_PRICE, STIT_UNIT_PRICE_OVERRIDE, STITM_CODE, STITM_DESC_TRANSLATION_ID, STITM_DESCRIPTION, STITM_MAX_NUMBER, STITM_MIN_NUMBER, STITM_NAME,
STITM_NAME_TRANSLATION_ID, STITM_OPERATION, STITM_PERIOD_END, STITM_PERIOD_START, STITM_PRESCRIBE_REQUIRED_STEPS, STITM_SEQUENCE, STITM_STAT_ITEM_TEMP_ID, STITM_STATEMENT_TEMPLATE_ID, STITM_STATUS, STITM_STEP_INTERVAL, STITM_STEP_INTERVAL_MANDATORY, STITM_STEP_INTERVAL_UOM_CODE, STITM_VERSION, STITT_CODE, STITT_DATA_ITEM_TYPE_ID, STITT_DESC_TRANSLATION_ID, STITT_DESCRIPTION, STITT_ITEM_CATEGORY, STITT_ITEM_TYPE, STITT_NAME, STITT_NAME_TRANSLATION_ID, STITT_PERIOD_END, STITT_PERIOD_START, STITT_STATEMENT_ITEM_TYPE, STITT_STATUS, STITT_TIMELINE_PERIOD_TPL_ID, STITT_VERSION, STTE_BASE_CURRENCY_UOM_CODE, STTE_CODE, STTE_DATA_ITEM_TYPE_ID, STTE_DESC_TRANSLATION_ID, STTE_DESCRIPTION, STTE_DOCUMENT_TEMPLATE_ID, STTE_FINANCIAL_STATEMENT_TYPE, STTE_MANUALLY_CREATE, STTE_NAME, STTE_NAME_TRANSLATION_ID, STTE_ONLY_AUTO_GENERATE, STTE_PAYMENT_TERMS, STTE_PERIOD_END, STTE_PERIOD_START, STTE_STATEMENT_TYPE, STTE_STATUS, STTE_TIMELINE_PERIOD_TPL_ID, STTE_VERSION, TACO_CODE, TACO_COUNTRY, TACO_DESCRIPTION, TACO_NAME, TACO_PERIOD_END, TACO_PERIOD_START, TACO_TAX_RATE, TAX_CODE_ID, UNIT_OF_MEASURE_ID, UNOM_CODE, UNOM_DESC_TRANSLATION_ID, UNOM_DESCRIPTION, UNOM_NAME, UNOM_NAME_TRANSLATION_ID, UNOM_UNIT_OF_MEASURE_TYPE FROM V_FINANCIAL_STATEMENT_ITEM WHERE (STATEMENT_ID = :1)
|
| 4zjyxa6sscnj6 |
SELECT V_ROWNUM, APPLIED_TIMELINE_POINT_TPL_ID, DAIT_CODE, DAIT_DATA_TYPE_ID, DAIT_DESC_TRANSLATION_ID, DAIT_DESCRIPTION, DAIT_DISPLAY_SEQUENCE, DAIT_FORMAT_MASK, DAIT_MULTIPLICITY, DAIT_NAME, DAIT_NAME_TRANSLATION_ID, DAIT_PERIOD_END, DAIT_PERIOD_START, DAIT_UOM_CODE, DATA_ITEM_TYPE_ID, INME_ID, INME_TRANSACTION_ID, INMET_CODE, INMET_DESC_TRANSLATION_ID, INMET_DESCRIPTION, INMET_INVENTORY_PERSPECTIVE, INMET_NAME, INMET_NAME_TRANSLATION_ID, INMET_OPERATION, INMET_PERIOD_END, INMET_PERIOD_START, INMET_VERSION, INMO_APPLIED_TIMESTAMP, INMO_COMMENTS, INMO_MOVEMENT_PERIOD_END, INMO_MOVEMENT_PERIOD_START, INMO_QUANTITY, INMO_SOURCE, INMO_STATUS, INMO_TRANSACTION_ID, INMOT_CODE, INMOT_DATA_ITEM_TYPE_ID, INMOT_DESC_TRANSLATION_ID, INMOT_DESCRIPTION, INMOT_NAME, INMOT_NAME_TRANSLATION_ID, INMOT_PERIOD_END, INMOT_PERIOD_START, INMOT_VERSION, INVENTORY_ID, INVENTORY_MEMBERSHIP_TPL_ID, INVENTORY_MOVEMENT_ID, INVENTORY_MOVEMENT_TPL_ID, INVENTORY_TPL_ID, UNIT_OF_MEASURE_ID, UNOM_CODE, UNOM_DESC_TRANSLATION_ID, UNOM_DESCRIPTION, UNOM_NAME, UNOM_NAME_TRANSLATION_ID, UNOM_UNIT_OF_MEASURE_TYPE FROM V_INVENTORY_MOVEMENT WHERE ((((INMO_MOVEMENT_PERIOD_START = :1) AND (INVENTORY_MEMBERSHIP_TPL_ID IN (:2, :3))) AND (INMO_STATUS = :4)) AND (INVENTORY_ID = :5))
|
| 55j6pw2scmuna |
SELECT V_ROWNUM, CONT_CONTRACT_CODE, CONT_CONTRACT_TEMPLATE_ID, CONT_CUSTOMER_ID, CONT_DESCRIPTION, CONT_NAME, CONT_PERIOD_END, CONT_PERIOD_START, CONT_REFERENCE_NUMBER, CONT_STATUS, CONT_TRANSACTION_ID, CONTRACT_ID, CONTRACT_SCHED_PERIOD_ID, CONTRACT_SCHED_QUANTITY_ID, CONTRACT_SCHEDULE_ID, COSC_CONTRACT_ID, COSC_CONTRACT_SCHED_GROUP_ID, COSC_CREATED_FOR_TIMESTAMP, COSC_ENTITY_TEMPLATE_ID, COSC_NAME, COSC_RECORDED_TIMESTAMP, COSC_SCHED_FOR_PERIOD_END, COSC_SCHED_FOR_PERIOD_START, COSC_SOURCE, COSC_STATUS, COSC_TRANSACTION_ID, COSP_CONTRACT_SCHEDULE_ID, COSP_PERIOD_TEMPLATE_ID, COSP_SCHEDULE_PERIOD_END, COSP_SCHEDULE_PERIOD_QTY_TOTAL, COSP_SCHEDULE_PERIOD_START, COSP_STATUS, COSP_TRANSACTION_ID, COSQ_COMMENTS, COSQ_CONTRACT_SCHED_PERIOD_ID, COSQ_COUNTER_PARTY, COSQ_MODIFIED, COSQ_QUANTITY, COSQ_QUANTITY_TEMPLATE_ID, COSQ_SERVICE_ID, COSQ_SOURCE, COSQ_STATUS, COSQ_TRANSACTION_ID, DAIT_CODE, DAIT_DATA_TYPE_ID, DAIT_DESC_TRANSLATION_ID, DAIT_DESCRIPTION, DAIT_DISPLAY_SEQUENCE, DAIT_FORMAT_MASK, DAIT_MULTIPLICITY, DAIT_NAME, DAIT_NAME_TRANSLATION_ID, DAIT_PERIOD_END, DAIT_PERIOD_START, DAIT_UOM_CODE, DATA_ITEM_TYPE_ID, ENTE_CODE, ENTE_CREATED_ON, ENTE_DATA_ITEM_TYPE_ID, ENTE_DESC_TRANSLATION_ID, ENTE_DESCRIPTION, ENTE_INSTANCE_TYPE_CODE, ENTE_NAME, ENTE_NAME_TRANSLATION_ID, ENTE_PERIOD_END, ENTE_PERIOD_START, ENTE_PERIOD_TEMPLATE_ID, ENTE_PROC_TEMP_TYPE_CODE, ENTE_SOURCE, ENTE_TIMELINE_PERIOD_TPL_ID, ENTE_TYPE,
ENTE_VERSION, ENTITY_TEMPLATE_ID, QUANTITY_TEMPLATE_ID, QUTE_CODE, QUTE_DATA_ITEM_TYPE_ID, QUTE_DESC_TRANSLATION_ID, QUTE_DESCRIPTION, QUTE_DISPLAY_SEQUENCE, QUTE_ENTERABLE, QUTE_FORMAT_MASK, QUTE_INSTANCE_TYPE_CODE, QUTE_NAME, QUTE_NAME_TRANSLATION_ID, QUTE_PERIOD_END, QUTE_PERIOD_START, QUTE_PRTT_CODE, QUTE_SERVICE_ID, QUTE_SOURCE, QUTE_TYPE, QUTE_VERSION, QUTE_VIEWABLE, SERV_CODE, SERV_DESC_TRANSLATION_ID, SERV_DESCRIPTION, SERV_NAME, SERV_NAME_TRANSLATION_ID, SERV_PERIOD_END, SERV_PERIOD_START, SERV_TRADABLE, SERV_TRANSFERABLE, SERV_TYPE, SERV_UOM_CODE, SERV_VERSION, SERVICE_ID FROM V_CONTRACT_SCHED_QUANTITY WHERE (CONTRACT_SCHEDULE_ID = :1) ORDER BY COSP_SCHEDULE_PERIOD_START ASC, QUTE_NAME ASC, SERV_NAME ASC, COSQ_COUNTER_PARTY ASC, COSQ_STATUS ASC |
| 5s61cr0mwd9bx | SELECT TRANSPORTER_NOM_QTY_EAV_ID, CREATED_BY, CREATED_ON, ENTITY_ATTRIBUTE_TYPE_ID, LAST_UPDATED_BY, LAST_UPDATED_ON, VALUE, TRANSPORTER_NOMINATION_QTY_ID FROM TRANSPORTER_NOM_QTY_EAV WHERE (TRANSPORTER_NOMINATION_QTY_ID = :1) |
| 5y45pvq79tr8q |
SELECT V_ROWNUM, APPLIED_TIMELINE_POINT_TPL_ID, DAIT_CODE, DAIT_DATA_TYPE_ID, DAIT_DESC_TRANSLATION_ID, DAIT_DESCRIPTION, DAIT_DISPLAY_SEQUENCE, DAIT_FORMAT_MASK, DAIT_MULTIPLICITY, DAIT_NAME, DAIT_NAME_TRANSLATION_ID, DAIT_PERIOD_END, DAIT_PERIOD_START, DAIT_UOM_CODE, DATA_ITEM_TYPE_ID, INME_ID, INME_TRANSACTION_ID, INMET_CODE, INMET_DESC_TRANSLATION_ID, INMET_DESCRIPTION, INMET_INVENTORY_PERSPECTIVE, INMET_NAME, INMET_NAME_TRANSLATION_ID, INMET_OPERATION, INMET_PERIOD_END, INMET_PERIOD_START, INMET_VERSION, INMO_APPLIED_TIMESTAMP, INMO_COMMENTS, INMO_MOVEMENT_PERIOD_END, INMO_MOVEMENT_PERIOD_START, INMO_QUANTITY, INMO_SOURCE, INMO_STATUS, INMO_TRANSACTION_ID, INMOT_CODE, INMOT_DATA_ITEM_TYPE_ID, INMOT_DESC_TRANSLATION_ID, INMOT_DESCRIPTION, INMOT_NAME, INMOT_NAME_TRANSLATION_ID, INMOT_PERIOD_END, INMOT_PERIOD_START, INMOT_VERSION, INVENTORY_ID, INVENTORY_MEMBERSHIP_TPL_ID, INVENTORY_MOVEMENT_ID, INVENTORY_MOVEMENT_TPL_ID, INVENTORY_TPL_ID, UNIT_OF_MEASURE_ID, UNOM_CODE, UNOM_DESC_TRANSLATION_ID, UNOM_DESCRIPTION, UNOM_NAME, UNOM_NAME_TRANSLATION_ID, UNOM_UNIT_OF_MEASURE_TYPE FROM V_INVENTORY_MOVEMENT WHERE ((((((INMO_MOVEMENT_PERIOD_END = :1) AND (INMO_MOVEMENT_PERIOD_START = :2)) AND (INVENTORY_MEMBERSHIP_TPL_ID IN (:3, :4))) AND (INMO_STATUS = :5)) AND (INVENTORY_MOVEMENT_TPL_ID IN (:6, :7))) AND (INVENTORY_ID = :8))
|
| 7tqhpzb1urq6b | update JIRepositoryCache set data=:1, version=:2, version_date=:3, item_reference=:4 where id=:5 |
| 7zqxdx71xw5fj | INSERT INTO ALLOCATION (ALLOCATION_ID, ALLOCATION_CONTEXT_ID, ALLOCATION_GROUP_ID, ALLOCATION_PERIOD_END, ALLOCATION_PERIOD_START, ALLOCATION_TOTAL, CREATED_BY, CREATED_FOR_TIMESTAMP, CREATED_ON, ENTITY_TEMPLATE_ID, LAST_UPDATED_BY, LAST_UPDATED_ON, RECORDED_TIMESTAMP, SOURCE, STATUS, TRANSACTION_ID) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16) |
| 7zy39rpv5r3sk |
select
substr(A.tablespace_name, 1, 20) as TSname,
round(A.size_mb) as alloc_mb,
round(A.size_mb-B.free_mb) as used_mb,
round(((A.size_mb-B.free_mb)/A.size_mb)*100) as "cur_used%",
decode(A.auto_X, '0', 'NO', 'YES') as auto_ext,
round(A.max_mb) as max_alloc_mb,
round(((A.size_mb-B.free_mb)/A.max_mb)*100) as "max_used%"
from
( select
D.tablespace_name,
sum(D.bytes)/1024/1024 as Size_Mb,
sum(decode(D.autoextensible, 'YES', 1, 0)) as auto_X,
sum(decode(D.AUTOEXTENSIBLE, 'YES', D.MAXBYTES, D.bytes))/1024/1024 as max_Mb
from
dba_data_files D
group by D.tablespace_name
) A,
( select
F.tablespace_name,
sum(F.bytes)/1024/1024 as free_mb
from
dba_free_space F
group by F.tablespace_name
) B
where
A.tablespace_name = B.tablespace_name
order by 1
|
| 8hyapfv34sbgw | INSERT INTO ALLOCATION_QUANTITY (ALLOCATION_QUANTITY_ID, COMMENTS, CONTRACT_ID, COUNTER_PARTY, CREATED_BY, CREATED_ON, FACILITY_COMPONENT_ID, LAST_UPDATED_BY, LAST_UPDATED_ON, MODIFIED, QUANTITY, QUANTITY_TEMPLATE_ID, SERVICE_ID, SOURCE, STATUS, ALLOCATION_PERIOD_ID) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16) |
| 8rgqc28t64uu0 | UPDATE INVENTORY_MOVEMENT SET LAST_UPDATED_ON = :1, STATUS = :2 WHERE (INVENTORY_MOVEMENT_ID = :3) |
| 8tgz5qhb8k1tf | SELECT V_ROWNUM, CONT_CODE, CONT_DESCRIPTION, CONT_NAME, CONT_PERIOD_END, CONT_PERIOD_START, CONT_REFERENCE_NUMBER, CONT_SERV_ENTITLEMENT_ID, CONT_STATUS, CONT_TRANSACTION_ID, CONTRACT_ID, CONTRACT_PARENT_ID, CONTRACT_SERV_ENT_TPL_ID, CONTRACT_SERVICE_TEMPLATE_ID, COSEN_CONTRACT_SERVICE_ID, COSEN_PERIOD_END, COSEN_PERIOD_START, COSEN_SERVICE_PROVISION_ID, COSEN_STATUS, COST_CODE, COST_DESCIPTION, COST_NAME, COST_PERIOD_END, COST_PERIOD_START, COST_VERSION, CSET_CODE, CSET_DATA_ITEM_TYPE_ID, CSET_DESCRIPTION, CSET_NAME, CSET_PERIOD_END, CSET_PERIOD_START, CSET_VERSION, DIT_DESCRIPTION, DIT_DESCRIPTION_TRANS_ID, DIT_NAME, DIT_NAME_TRANS_ID, SERV_DESCRIPTION, SERV_NAME, SERV_PERIOD_END, SERV_PERIOD_START, SERV_TRADABLE, SERV_TRANSFERABLE, SERV_TYPE, SERVICE_ID FROM V_CONTRACT_SERVICE_ENTITLEMENT WHERE ((((:1 >= COSEN_PERIOD_START) AND ((:2 < COSEN_PERIOD_END) OR (COSEN_PERIOD_END IS NULL))) AND (CONTRACT_SERV_ENT_TPL_ID IN (:3, :4))) AND (CONTRACT_ID = :5)) |
| 934757hjs3s17 | insert into JIAccessEvent (user_id, event_date, resource_id, updating, id) values (:1, :2, :3, :4, :5) |
| 96jyuypxnpa8f | INSERT INTO TRANSPORTER_NOMINATION_QTY (TRANSPORTER_NOMINATION_QTY_ID, COMMENTS, COUNTER_PARTY, CREATED_BY, CREATED_ON, CUSTOMER_ID, FACILITY_COMPONENT_ID, LAST_UPDATED_BY, LAST_UPDATED_ON, MODIFIED, QUANTITY, QUANTITY_TEMPLATE_ID, SOURCE, STATUS, TRANSACTION_ID, TRANSPORTER_NOM_PERIOD_ID) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16) |
| 9bx4fzd3uzp3m | SELECT V_USER_MESSAGE_CATEGORY_ID, CONFIDENTIAL, CONTACT_DETAIL_CODE, CONTACT_DETAIL_ID, CONTACT_DETAIL_TYPE, CONTACT_DETAILS, CONTACT_ID, CONTACT_NAME, DEFAULT_OPTION, DEPARTMENT, DISPLAY_SEQUENCE, FORENAME, LINKED_TO, LINKED_TO_ID, MDTP_CODE, MECA_CODE, MECA_DESCRIPTION, MECA_NAME, MECG_CODE, MECG_DESCRIPTION, MECG_NAME, MESSAGE_CATEGORY_GROUP_ID, MESSAGE_CATEGORY_ID, PRIMARY_FLAG, ROLE, SURNAME, TITLE, USERNAME FROM V_USER_MESSAGE_CATEGORY WHERE (USERNAME = :1) ORDER BY MECG_NAME ASC, DISPLAY_SEQUENCE ASC |
| 9kyy0t0g4ndar | SELECT lower(u.username), a.authority FROM Users u, authorities a WHERE lower(u.username)=lower(a.username) AND lower(u.username) = lower(:1) |
| 9zr8tq7f9368x | SELECT SERVICE_SCHED_QTY_EAV_ID, CREATED_BY, CREATED_ON, ENTITY_ATTRIBUTE_TYPE_ID, LAST_UPDATED_BY, LAST_UPDATED_ON, VALUE, SERVICE_SCHED_QUANTITY_ID FROM SERVICE_SCHED_QTY_EAV WHERE (SERVICE_SCHED_QUANTITY_ID = :1) |
| ajwx89rzvbd4j | SELECT DISPATCH_QUANTITY_ID, COMMENTS, CONTRACT_ID, COUNTER_PARTY, CREATED_BY, CREATED_ON, DISPATCH_PERIOD_ID, FACILITY_COMPONENT_ID, FACILITY_OPERATION_ID, LAST_UPDATED_BY, LAST_UPDATED_ON, MODIFIED, QUANTITY, QUANTITY_TEMPLATE_ID, RECORDED_TIMESTAMP, SOURCE, STATUS, TRANSACTION_ID FROM DISPATCH_QUANTITY WHERE (DISPATCH_QUANTITY_ID = :1) |
| at4n1d4pfxap7 | SELECT V_ROWNUM, CODE, DATA_ITEM_TYPE_ID, DESCRIPTION, PARA_NAME, PARAMETER_ID, PARAMETER_TEMPLATE_ID, PATE_NAME, PERIOD_END, PERIOD_START, PROCESS_IDENTIFIER, PROCESS_TYPE_CODE FROM V_PARAMETER WHERE ((PROCESS_IDENTIFIER = :1) AND (PROCESS_TYPE_CODE = :2)) |
| cgt1k2w26nqg8 | INSERT INTO INVENTORY_MOVEMENT (INVENTORY_MOVEMENT_ID, APPLIED_TIMESTAMP, COMMENTS, CREATED_BY, CREATED_ON, INVENTORY_MOVEMENT_TPL_ID, LAST_UPDATED_BY, LAST_UPDATED_ON, MOVEMENT_PERIOD_END, MOVEMENT_PERIOD_START, QUANTITY, SOURCE, STATUS, TRANSACTION_ID) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14) |
| cw40bhgsyy5jf | INSERT INTO INVENTORY_MEMBERSHIP (INVENTORY_MEMBERSHIP_ID, CREATED_BY, CREATED_ON, INVENTORY_ID, INVENTORY_MEMBERSHIP_TPL_ID, LAST_UPDATED_BY, LAST_UPDATED_ON, TRANSACTION_ID, INVENTORY_MOVEMENT_ID) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9) |
| d2jk9jk3bv88z | select this_.id as id2_0_, this_.version as version2_0_, this_.uri as uri2_0_, this_.hidden as hidden2_0_, this_.name as name2_0_, this_.label as label2_0_, this_.description as descript7_2_0_, this_.parent_folder as parent8_2_0_, this_.creation_date as creation9_2_0_, this_.update_date as update10_2_0_ from JIResourceFolder this_ where (this_.uri=:1) |
| d840afmc48nwr |
SELECT V_ROWNUM, CONT_CONTRACT_CODE, CONT_CONTRACT_TEMPLATE_ID, CONT_CUSTOMER_ID, CONT_DESCRIPTION, CONT_NAME, CONT_PERIOD_END, CONT_PERIOD_START, CONT_REFERENCE_NUMBER, CONT_STATUS, CONT_TRANSACTION_ID, CONTRACT_ID, DIPE_DISP_PER_PERIOD_END, DIPE_DISP_PER_PERIOD_START, DIPE_DISPATCH_ID, DIPE_DISPATCH_PERIOD_QTY_TOTAL, DIPE_PERIOD_TEMPLATE_ID, DIPE_RECORDED_TIMESTAMP, DIPE_STATUS, DIPE_TRANSACTION_ID, DIQU_COMMENTS, DIQU_CONTRACT_ID, DIQU_COUNTER_PARTY, DIQU_DISPATCH_PERIOD_ID, DIQU_FACILITY_COMPONENT_ID, DIQU_FACILITY_OPERATION_ID, DIQU_MODIFIED, DIQU_QUANTITY, DIQU_QUANTITY_TEMPLATE_ID, DIQU_RECORDED_TIMESTAMP, DIQU_SOURCE, DIQU_STATUS, DIQU_TRANSACTION_ID, DISP_CREATED_FOR_TIMESTAMP, DISP_DISPATCH_GROUP_ID, DISP_DISPATCH_PERIOD_END, DISP_DISPATCH_PERIOD_START, DISP_ENTITY_TEMPLATE_ID, DISP_EXTERNAL_IDENTIFIER, DISP_RECORDED_TIMESTAMP, DISP_SOURCE, DISP_STATUS, DISP_TRANSACTION_ID, DISPATCH_ID, DISPATCH_PERIOD_ID, DISPATCH_QUANTITY_ID, FACILITY_COMPONENT_ID, FACILITY_COMPONENT_TEMPLATE_ID, FACILITY_OPERATION_ID, FACO_CODE, FACO_DESC_TRANSLATION_ID, FACO_DESCRIPTION, FACO_NAME, FACO_NAME_TRANSLATION_ID, FACO_PERIOD_END, FACO_PERIOD_START, FACO_TYPE, FAOP_CODE, FAOP_DESCRIPTION, FAOP_DIRECTION, FAOP_NAME, FAOP_PERIOD_END, FAOP_PERIOD_START, FAOP_RECORDED_TIMESTAMP, FAOP_STATUS, FAOP_TRANSACTION_ID, FAOP_VERSION, VQT_DAIT_CODE, VQT_DAIT_DATA_TYPE_ID, VQT_DAIT_DESC_TRANSLATION_ID, VQT_DAIT_DESCRIPTION, VQT_D
AIT_DISPLAY_SEQUENCE, VQT_DAIT_FORMAT_MASK, VQT_DAIT_MULTIPLICITY, VQT_DAIT_NAME, VQT_DAIT_NAME_TRANSLATION_ID, VQT_DAIT_PERIOD_END, VQT_DAIT_PERIOD_START, VQT_DAIT_UOM_CODE, VQT_DATA_ITEM_TYPE_ID, VQT_ENTE_CODE, VQT_ENTE_DESC_TRANSLATION_ID, VQT_ENTE_DESCRIPTION, VQT_ENTE_INSTANCE_TYPE_CODE, VQT_ENTE_NAME, VQT_ENTE_NAME_TRANSLATION_ID, VQT_ENTE_PERIOD_END, VQT_ENTE_PERIOD_START, VQT_ENTE_PERIOD_TEMPLATE_ID, VQT_ENTE_PRTT_CODE, VQT_ENTE_SOURCE, VQT_ENTE_TYPE, VQT_ENTE_VERSION, VQT_ENTITY_TEMPLATE_ID, VQT_QUANTITY_TEMPLATE_ID, VQT_QUTE_CODE, VQT_QUTE_DATA_ITEM_TYPE_ID, VQT_QUTE_DESC_TRANSLATION_ID, VQT_QUTE_DESCRIPTION, VQT_QUTE_DISPLAY_SEQUENCE, VQT_QUTE_ENTERABLE, VQT_QUTE_FORMAT_MASK, VQT_QUTE_INSTANCE_TYPE_CODE, VQT_QUTE_NAME, VQT_QUTE_NAME_TRANSLATION_ID, VQT_QUTE_PERIOD_END, VQT_QUTE_PERIOD_START, VQT_QUTE_PRTT_CODE, VQT_QUTE_SERVICE_ID, VQT_QUTE_SOURCE, VQT_QUTE_TYPE, VQT_QUTE_VERSION, VQT_QUTE_VIEWABLE, VQT_TIMELINE_PER_TEMP_ID, VQT_UNIT_OF_MEASURE_ID, VQT_UNOM_CODE, VQT_UNOM_DESC_TRANSLATION_ID, VQT_UNOM_DESCRIPTION, VQT_UNOM_NAME, VQT_UNOM_NAME_TRANSLATION_ID, VQT_UNOM_UNIT_OF_MEASURE_TYPE, VQT_V_ROWNUM FROM V_DISPATCH_CONTRACT_QTY WHERE ((((DISP_STATUS = :1) AND (DISP_ENTITY_TEMPLATE_ID = :2)) AND (DISP_DISPATCH_PERIOD_START = :3)) AND (DIQU_QUANTITY_TEMPLATE_ID = :4)) ORDER BY DIPE_DISP_PER_PERIOD_START ASC
|
| f6p3nh3hbps0d | SELECT NOMINATION_SCHEDULE_ID, CONTRACT_ID, CREATED_BY, CREATED_FOR_TIMESTAMP, CREATED_ON, ENTITY_TEMPLATE_ID, LAST_UPDATED_BY, LAST_UPDATED_ON, NAME, NOMINATION_SCHED_GROUP_ID, RECORDED_TIMESTAMP, SCHEDULED_FOR_PERIOD_END, SCHEDULED_FOR_PERIOD_START, SOURCE, STATUS, TRANSACTION_ID FROM NOMINATION_SCHEDULE WHERE (NOMINATION_SCHEDULE_ID = :1) |
| f84g9x2m8jqjy | SELECT BUSINESS_RULE_SERVICE_ID, CATEGORY, CREATED_BY, CREATED_ON, DESCRIPTION, DESCRIPTION_TRANSLATION_ID, LAST_UPDATED_BY, LAST_UPDATED_ON, LOCATION, NAME, NAME_TRANSLATION_ID, PERIOD_END, PERIOD_START, SERVICE_TYPE FROM BUSINESS_RULE_SERVICE WHERE (BUSINESS_RULE_SERVICE_ID = :1) |
| fdm797u0z63w3 | SELECT V_USER_PARAM_SYS_ROLE_PARAM_ID, CODE, CONFIG_PARAMETER_TYPE_ID, NAME, TYPE, USERNAME, VALUE FROM V_USER_PARAM_SYSTEM_ROLE_PARAM WHERE ((USERNAME = :1) AND (CODE = :2)) |
| ffs7zjud4c27w |
SELECT t0.V_ROWNUM, t0.APPLIED_TIMELINE_POINT_TPL_ID, t0.DAIT_CODE, t0.DAIT_DATA_TYPE_ID, t0.DAIT_DESC_TRANSLATION_ID, t0.DAIT_DESCRIPTION, t0.DAIT_DISPLAY_SEQUENCE, t0.DAIT_FORMAT_MASK, t0.DAIT_MULTIPLICITY, t0.DAIT_NAME, t0.DAIT_NAME_TRANSLATION_ID, t0.DAIT_PERIOD_END, t0.DAIT_PERIOD_START, t0.DAIT_UOM_CODE, t0.DATA_ITEM_TYPE_ID, t0.INME_ID, t0.INME_TRANSACTION_ID, t0.INMET_CODE, t0.INMET_DESC_TRANSLATION_ID, t0.INMET_DESCRIPTION, t0.INMET_INVENTORY_PERSPECTIVE, t0.INMET_NAME, t0.INMET_NAME_TRANSLATION_ID, t0.INMET_OPERATION, t0.INMET_PERIOD_END, t0.INMET_PERIOD_START, t0.INMET_VERSION, t0.INMO_APPLIED_TIMESTAMP, t0.INMO_COMMENTS, t0.INMO_MOVEMENT_PERIOD_END, t0.INMO_MOVEMENT_PERIOD_START, t0.INMO_QUANTITY, t0.INMO_SOURCE, t0.INMO_STATUS, t0.INMO_TRANSACTION_ID, t0.INMOT_CODE, t0.INMOT_DATA_ITEM_TYPE_ID, t0.INMOT_DESC_TRANSLATION_ID, t0.INMOT_DESCRIPTION, t0.INMOT_NAME, t0.INMOT_NAME_TRANSLATION_ID, t0.INMOT_PERIOD_END, t0.INMOT_PERIOD_START, t0.INMOT_VERSION, t0.INVENTORY_ID, t0.INVENTORY_MEMBERSHIP_TPL_ID, t0.INVENTORY_MOVEMENT_ID, t0.INVENTORY_MOVEMENT_TPL_ID, t0.INVENTORY_TPL_ID, t0.UNIT_OF_MEASURE_ID, t0.UNOM_CODE, t0.UNOM_DESC_TRANSLATION_ID, t0.UNOM_DESCRIPTION, t0.UNOM_NAME, t0.UNOM_NAME_TRANSLATION_ID, t0.UNOM_UNIT_OF_MEASURE_TYPE FROM V_INVENTORY_MOVEMENT t0 WHERE (((((t0.INMET_OPERATION = :1) AND (t0.INMO_STATUS <> :2)) AND (t0.INVENTORY_ID = :3)) AND (t0.INMET_INVENTORY_PERSPECTIVE IN (:4, :5, :6))) AN
D (t0.INMO_APPLIED_TIMESTAMP = (SELECT MAX(t1.INMO_APPLIED_TIMESTAMP) FROM V_INVENTORY_MOVEMENT t1 WHERE (((((t1.INMET_OPERATION = :7) AND (t1.INMO_STATUS <> :8)) AND (t1.INVENTORY_ID = :9)) AND (t1.INMET_INVENTORY_PERSPECTIVE IN (:10, :11, :12))) AND (t1.INMO_APPLIED_TIMESTAMP < :13))))) |
| fkkzmpkqjwu5j | SELECT NOMINATION_SCHED_PERIOD_EAV_ID, CREATED_BY, CREATED_ON, ENTITY_ATTRIBUTE_TYPE_ID, LAST_UPDATED_BY, LAST_UPDATED_ON, VALUE, NOMINATION_SCHED_PERIOD_ID FROM NOMINATION_SCHED_PERIOD_EAV WHERE (NOMINATION_SCHED_PERIOD_ID = :1) |
| g5hz3fvnwuu7c | SELECT BILLING_RUN_ID, BILLING_RUN_TEMPLATE_ID, BILLING_RUN_TYPE, CREATED_BY, CREATED_ON, LAST_UPDATED_BY, LAST_UPDATED_ON, MODIFIED, NAME, NOTES, PERIOD_END, PERIOD_START, RECORDED_TIMESTAMP, RUN_COMPLETION_TIMESTAMP, STATUS FROM BILLING_RUN WHERE (BILLING_RUN_ID = :1) |