APPS.OPI_DBI_JOB_TXN_STG_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 479: , MTL_MATERIAL_TRANSACTIONS MMT

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
483: AND MMT.transaction_source_type_id = 5 -- Jobs abd Schedules

Line 516: , MTL_MATERIAL_TRANSACTIONS MMT

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
520: AND MMT.transaction_source_type_id = 5 -- Jobs abd Schedules

Line 969: MTL_MATERIAL_TRANSACTIONS mmt,

965: 31,2,
966: 32,2,
967: 30,3) ETL_TYPE_ID
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

Line 1427: MTL_MATERIAL_TRANSACTIONS MMT_STG,

1423: gtv.transaction_date,
1424: gtv.accounted_flag
1425: ) GTV,
1426: GME_MATERIAL_DETAILS MTL_DTL,
1427: MTL_MATERIAL_TRANSACTIONS MMT_STG,
1428: mtl_system_items_b msi
1429: where
1430: GTV.organization_id = MTL_DTL.organization_id and
1431: GTV.doc_id = MTL_DTL.batch_id and

Line 4126: MTL_MATERIAL_TRANSACTIONS MMT,

4122: JOB_ID IN (
4123: SELECT /*+ ordered use_nl(mmt,mmta) index(log) parallel(mmt) parallel(mmta) */
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