[Home] [Help]
678: sum(primary_quantity) primary_quantity,
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
725: 32,2,
726: 30,3) ETL_TYPE_ID
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
919: sum(primary_quantity) primary_quantity,
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
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
974: mmt.organization_id = msi.organization_id and
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
4131: and mmt.transaction_action_id in (1, 27)