DBA Data[Home] [Help]

APPS.OPI_DBI_INV_CCA_PKG dependencies on MTL_MATERIAL_TRANSACTIONS

Line 835: From MTL_MATERIAL_TRANSACTIONS

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:

Line 1404: FROM mtl_material_transactions mmt ,

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

Line 2906: FROM mtl_material_transactions mmt,

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

Line 3188: FROM mtl_material_transactions mmt ,

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