eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OPI_DBI_JOB_TXN_STG_PKG dependencies on OPI_DBI_RUN_LOG_CURR

Line 478: FROM OPI_DBI_RUN_LOG_CURR LOG

474: , s_program_id
475: , s_program_login_id
476: , s_program_application_id
477: , s_request_id
478: FROM OPI_DBI_RUN_LOG_CURR LOG
479: , MTL_MATERIAL_TRANSACTIONS MMT
480: , MTL_PARAMETERS mtp
481: WHERE 1 = 1
482: AND MMT.transaction_action_id IN (1, 27, 31, 32, 30) -- Issue, Receipt, Completion, Return,Scrap

Line 515: FROM OPI_DBI_RUN_LOG_CURR LOG

511: , s_program_id
512: , s_program_login_id
513: , s_program_application_id
514: , s_request_id
515: FROM OPI_DBI_RUN_LOG_CURR LOG
516: , MTL_MATERIAL_TRANSACTIONS MMT
517: , MTL_PARAMETERS mtp
518: WHERE 1 = 1
519: AND MMT.transaction_action_id IN (1, 27, 31, 32, 30) -- Issue, Receipt, Completion, Return,Scrap

Line 656: OPI_DBI_RUN_LOG_CURR log

652: mtain.transaction_date,
653: SUM(mtain.BASE_TRANSACTION_VALUE) BASE_TRANSACTION_VALUE
654: from
655: mtl_transaction_accounts mtain,
656: OPI_DBI_RUN_LOG_CURR log
657: where
658: mtain.accounting_line_type = 7 /* WIP valuation */ and
659: mtain.transaction_source_type_id = 5 /* Job or schedule */ and
660: log.source = 1 and

Line 683: OPI_DBI_RUN_LOG_CURR log

679: sum(sum(primary_quantity)) over
680: (partition by mmtain.organization_id, mmtain.transaction_id) tot_primary_quantity
681: from
682: mtl_material_txn_allocations mmtain,
683: OPI_DBI_RUN_LOG_CURR log
684: where
685: log.source = 1 and
686: log.etl_id = 1 and
687: mmtain.organization_id = log.organization_id and

Line 731: OPI_DBI_RUN_LOG_CURR log

727: from
728: OPI_DBI_JOBS_TXN_MMT_STG mmt,
729: mtl_material_txn_allocations mmta,
730: mtl_system_items_b msi,
731: OPI_DBI_RUN_LOG_CURR log
732: where
733: mmt.organization_id = msi.organization_id and
734: mmt.inventory_item_id = msi.inventory_item_id and
735: mmt.transaction_action_id in (1, 27,31,32,30) and -- Issue, Receipt, Completion, Return,Scrap

Line 897: OPI_DBI_RUN_LOG_CURR log

893: mtain.transaction_date,
894: SUM(mtain.BASE_TRANSACTION_VALUE) BASE_TRANSACTION_VALUE
895: from
896: mtl_transaction_accounts mtain,
897: OPI_DBI_RUN_LOG_CURR log
898: where
899: mtain.accounting_line_type = 7 /* WIP valuation */ and
900: mtain.transaction_source_type_id = 5 /* Job or schedule */ and
901: log.source = 1 and

Line 924: OPI_DBI_RUN_LOG_CURR log

920: sum(sum(primary_quantity)) over
921: (partition by mmtain.organization_id, mmtain.transaction_id) tot_primary_quantity
922: from
923: mtl_material_txn_allocations mmtain,
924: OPI_DBI_RUN_LOG_CURR log
925: where
926: log.source = 1 and
927: log.etl_id = 1 and
928: mmtain.organization_id = log.organization_id and

Line 972: OPI_DBI_RUN_LOG_CURR log

968: from
969: MTL_MATERIAL_TRANSACTIONS mmt,
970: mtl_material_txn_allocations mmta,
971: mtl_system_items_b msi,
972: OPI_DBI_RUN_LOG_CURR log
973: where
974: mmt.organization_id = msi.organization_id and
975: mmt.inventory_item_id = msi.inventory_item_id and
976: mmt.transaction_action_id in (1, 27,31,32,30) and -- Issue, Receipt, Completion, Return,Scrap

Line 1046: l_from_date OPI_DBI_RUN_LOG_CURR.FROM_BOUND_DATE%TYPE;

1042: l_row_count NUMBER;
1043: l_err_num NUMBER;
1044: l_err_msg VARCHAR2(255);
1045: l_proc_name VARCHAR2(255);
1046: l_from_date OPI_DBI_RUN_LOG_CURR.FROM_BOUND_DATE%TYPE;
1047: l_to_date OPI_DBI_RUN_LOG_CURR.FROM_BOUND_DATE%TYPE;
1048: l_status VARCHAR2(30);
1049: l_industry VARCHAR2(30);
1050: l_opi_schema VARCHAR2(30);

Line 1047: l_to_date OPI_DBI_RUN_LOG_CURR.FROM_BOUND_DATE%TYPE;

1043: l_err_num NUMBER;
1044: l_err_msg VARCHAR2(255);
1045: l_proc_name VARCHAR2(255);
1046: l_from_date OPI_DBI_RUN_LOG_CURR.FROM_BOUND_DATE%TYPE;
1047: l_to_date OPI_DBI_RUN_LOG_CURR.FROM_BOUND_DATE%TYPE;
1048: l_status VARCHAR2(30);
1049: l_industry VARCHAR2(30);
1050: l_opi_schema VARCHAR2(30);
1051:

Line 1052: CURSOR OPI_DBI_RUN_LOG_CURR_CSR IS

1048: l_status VARCHAR2(30);
1049: l_industry VARCHAR2(30);
1050: l_opi_schema VARCHAR2(30);
1051:
1052: CURSOR OPI_DBI_RUN_LOG_CURR_CSR IS
1053: select
1054: from_bound_date,
1055: to_bound_date
1056: from

Line 1057: OPI_DBI_RUN_LOG_CURR

1053: select
1054: from_bound_date,
1055: to_bound_date
1056: from
1057: OPI_DBI_RUN_LOG_CURR
1058: where
1059: ETL_ID = 1 and
1060: source = 2;
1061:

Line 1069: OPEN OPI_DBI_RUN_LOG_CURR_CSR;

1065:
1066: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
1067:
1068: l_stmt_num := 10;
1069: OPEN OPI_DBI_RUN_LOG_CURR_CSR;
1070: FETCH OPI_DBI_RUN_LOG_CURR_CSR INTO l_from_date,l_to_date;
1071:
1072: l_stmt_num :=15;
1073: IF (OPI_DBI_RUN_LOG_CURR_CSR%NOTFOUND) THEN

Line 1070: FETCH OPI_DBI_RUN_LOG_CURR_CSR INTO l_from_date,l_to_date;

1066: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
1067:
1068: l_stmt_num := 10;
1069: OPEN OPI_DBI_RUN_LOG_CURR_CSR;
1070: FETCH OPI_DBI_RUN_LOG_CURR_CSR INTO l_from_date,l_to_date;
1071:
1072: l_stmt_num :=15;
1073: IF (OPI_DBI_RUN_LOG_CURR_CSR%NOTFOUND) THEN
1074: --{

Line 1073: IF (OPI_DBI_RUN_LOG_CURR_CSR%NOTFOUND) THEN

1069: OPEN OPI_DBI_RUN_LOG_CURR_CSR;
1070: FETCH OPI_DBI_RUN_LOG_CURR_CSR INTO l_from_date,l_to_date;
1071:
1072: l_stmt_num :=15;
1073: IF (OPI_DBI_RUN_LOG_CURR_CSR%NOTFOUND) THEN
1074: --{
1075: RAISE NO_DATA_FOUND;
1076: --}
1077: END IF;

Line 1078: CLOSE OPI_DBI_RUN_LOG_CURR_CSR;

1074: --{
1075: RAISE NO_DATA_FOUND;
1076: --}
1077: END IF;
1078: CLOSE OPI_DBI_RUN_LOG_CURR_CSR;
1079:
1080: /* GTV is summarised and joined with MMT Staging. GTV gives the transaction value while
1081: MMT Staging gives the quantity. Join with GME_MATERIAL_DETAILS is required to get the
1082: cost alloc factor for products. */

Line 1267: l_from_date OPI_DBI_RUN_LOG_CURR.FROM_BOUND_DATE%TYPE;

1263: l_row_count NUMBER;
1264: l_err_num NUMBER;
1265: l_err_msg VARCHAR2(255);
1266: l_proc_name VARCHAR2(255);
1267: l_from_date OPI_DBI_RUN_LOG_CURR.FROM_BOUND_DATE%TYPE;
1268: l_to_date OPI_DBI_RUN_LOG_CURR.FROM_BOUND_DATE%TYPE;
1269: l_status VARCHAR2(30);
1270: l_industry VARCHAR2(30);
1271: l_opi_schema VARCHAR2(30);

Line 1268: l_to_date OPI_DBI_RUN_LOG_CURR.FROM_BOUND_DATE%TYPE;

1264: l_err_num NUMBER;
1265: l_err_msg VARCHAR2(255);
1266: l_proc_name VARCHAR2(255);
1267: l_from_date OPI_DBI_RUN_LOG_CURR.FROM_BOUND_DATE%TYPE;
1268: l_to_date OPI_DBI_RUN_LOG_CURR.FROM_BOUND_DATE%TYPE;
1269: l_status VARCHAR2(30);
1270: l_industry VARCHAR2(30);
1271: l_opi_schema VARCHAR2(30);
1272:

Line 1273: CURSOR OPI_DBI_RUN_LOG_CURR_CSR IS

1269: l_status VARCHAR2(30);
1270: l_industry VARCHAR2(30);
1271: l_opi_schema VARCHAR2(30);
1272:
1273: CURSOR OPI_DBI_RUN_LOG_CURR_CSR IS
1274: select
1275: from_bound_date,
1276: to_bound_date
1277: from

Line 1278: OPI_DBI_RUN_LOG_CURR

1274: select
1275: from_bound_date,
1276: to_bound_date
1277: from
1278: OPI_DBI_RUN_LOG_CURR
1279: where
1280: ETL_ID = 1 and
1281: source = 2;
1282:

Line 1290: OPEN OPI_DBI_RUN_LOG_CURR_CSR;

1286:
1287: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
1288:
1289: l_stmt_num := 10;
1290: OPEN OPI_DBI_RUN_LOG_CURR_CSR;
1291: FETCH OPI_DBI_RUN_LOG_CURR_CSR INTO l_from_date,l_to_date;
1292:
1293: l_stmt_num :=15;
1294: IF (OPI_DBI_RUN_LOG_CURR_CSR%NOTFOUND) THEN

Line 1291: FETCH OPI_DBI_RUN_LOG_CURR_CSR INTO l_from_date,l_to_date;

1287: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
1288:
1289: l_stmt_num := 10;
1290: OPEN OPI_DBI_RUN_LOG_CURR_CSR;
1291: FETCH OPI_DBI_RUN_LOG_CURR_CSR INTO l_from_date,l_to_date;
1292:
1293: l_stmt_num :=15;
1294: IF (OPI_DBI_RUN_LOG_CURR_CSR%NOTFOUND) THEN
1295: --{

Line 1294: IF (OPI_DBI_RUN_LOG_CURR_CSR%NOTFOUND) THEN

1290: OPEN OPI_DBI_RUN_LOG_CURR_CSR;
1291: FETCH OPI_DBI_RUN_LOG_CURR_CSR INTO l_from_date,l_to_date;
1292:
1293: l_stmt_num :=15;
1294: IF (OPI_DBI_RUN_LOG_CURR_CSR%NOTFOUND) THEN
1295: --{
1296: RAISE NO_DATA_FOUND;
1297: --}
1298: END IF;

Line 1299: CLOSE OPI_DBI_RUN_LOG_CURR_CSR;

1295: --{
1296: RAISE NO_DATA_FOUND;
1297: --}
1298: END IF;
1299: CLOSE OPI_DBI_RUN_LOG_CURR_CSR;
1300:
1301: /* GTV is summarised and joined with MMT. GTV gives the transaction value while
1302: MMT gives the quantity. Join with GME_MATERIAL_DETAILS is required to get the
1303: cost alloc factor for products. */

Line 4128: OPI_DBI_RUN_LOG_CURR log

4124: distinct decode(mmta.primary_quantity, null, mmt.transaction_source_id, mmta.repetitive_schedule_id) JOB_ID
4125: FROM
4126: MTL_MATERIAL_TRANSACTIONS MMT,
4127: mtl_material_txn_allocations mmta,
4128: OPI_DBI_RUN_LOG_CURR log
4129: WHERE
4130: MMT.TRANSACTION_ID >= log.Next_start_txn_id
4131: and mmt.transaction_action_id in (1, 27)
4132: and mmt.transaction_source_type_id = 5