DBA Data[Home] [Help]

APPS.CSI_RMA_RECEIPT_PUB dependencies on MTL_SECONDARY_INVENTORIES

Line 563: mtl_secondary_inventories msi,

559: mmt.creation_date creation_date -- bug 4026148
560: FROM hr_all_organization_units haou,
561: mtl_transaction_lot_numbers mtln,
562: mtl_unit_transactions mut,
563: mtl_secondary_inventories msi,
564: mtl_material_transactions mmt
565: WHERE mmt.transaction_id = p_mtl_txn_id
566: AND mmt.transaction_id = mut.transaction_id(+)
567: AND mmt.transaction_id = mtln.transaction_id(+)

Line 594: mtl_secondary_inventories msi,

590: mmt.creation_date creation_date -- bug 4026148
591: FROM hr_all_organization_units haou,
592: mtl_transaction_lot_numbers mtln,
593: mtl_unit_transactions mut,
594: mtl_secondary_inventories msi,
595: mtl_material_transactions mmt
596: WHERE mmt.transaction_id = p_mtl_txn_id
597: AND mmt.subinventory_code = msi.secondary_inventory_name
598: AND mmt.organization_id = msi.organization_id

Line 624: mtl_secondary_inventories msi,

620: mmt.transaction_type_id transaction_type_id,
621: mmt.creation_date creation_date -- bug 4026148
622: FROM hr_all_organization_units haou,
623: mtl_transaction_lot_numbers mtln,
624: mtl_secondary_inventories msi,
625: mtl_material_transactions mmt
626: WHERE mmt.transaction_id = p_mtl_txn_id
627: AND mmt.transaction_id = mtln.transaction_id(+)
628: AND mmt.subinventory_code = msi.secondary_inventory_name