831: TRANSFER_SUBINVENTORY,
832: TRANSACTION_DATE,
833: TRANSACTION_TYPE_ID,
834: PRIMARY_QUANTITY
835: From MTL_MATERIAL_TRANSACTIONS
836: Where Transaction_date >= s_global_start_date
837: and Transaction_source_type_id = 9 ;
838:
839:
1400: DECODE (mmt.transaction_type_id ,
1401: 5 ,GTV.subinventory_code,
1402: mmt.subinventory_code) subinventory_code,
1403: SUM (gtv.txn_base_value) transaction_base_value
1404: FROM mtl_material_transactions mmt ,
1405: (SELECT gt.*
1406: FROM gmf_transaction_valuation gt,
1407: opi_dbi_org_le_temp olt
1408: WHERE olt.organization_id = gt.organization_id
2902: 1, mmt.transfer_subinventory,
2903: mmt.subinventory_code),
2904: mmt.subinventory_code) subinventory_code,
2905: sum (mta.base_transaction_value) base_transaction_value
2906: FROM mtl_material_transactions mmt,
2907: mtl_transaction_accounts mta,
2908: opi_dbi_conc_prog_run_log log
2909: WHERE log.etl_type = C_ETL_TYPE
2910: AND log.driving_table_code = C_LOG_MMT_DRV_TBL
3184: DECODE (mmt.transaction_type_id ,
3185: 5 ,GTV.subinventory_code,
3186: mmt.subinventory_code) subinventory_code,
3187: SUM (gtv.txn_base_value) transaction_base_value
3188: FROM mtl_material_transactions mmt ,
3189: (SELECT gt.*
3190: FROM gmf_transaction_valuation gt,
3191: opi_dbi_org_le_temp olt
3192: WHERE olt.organization_id = gt.organization_id