DBA Data[Home] [Help]

APPS.CSI_ORDER_FULFILL_PUB dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 3628: mtl_transaction_lot_numbers mtln,

3624: mmt.transaction_action_id mtl_action_id,
3625: mmt.transaction_source_type_id mtl_source_type_id,
3626: mmt.transaction_source_id mtl_source_id
3627: FROM mtl_unit_transactions mut,
3628: mtl_transaction_lot_numbers mtln,
3629: mtl_material_transactions mmt,
3630: mtl_transaction_types mtt
3631: WHERE mut.serial_number = p_serial_number
3632: AND mut.inventory_item_id = p_item_id

Line 3766: mtl_transaction_lot_numbers mtln,

3762: UNION
3763: SELECT mut.serial_number,
3764: mut.inventory_item_id
3765: FROM mtl_material_transactions mmt,
3766: mtl_transaction_lot_numbers mtln,
3767: mtl_unit_transactions mut
3768: WHERE mmt.transaction_source_type_id = 5
3769: AND mmt.transaction_action_id = 1
3770: AND mmt.inventory_item_id = px_config_rec.sub_config_item_id

Line 10993: mtl_transaction_lot_numbers mtln,

10989: FROM oe_order_headers_all ooh,
10990: oe_order_lines_all ool,
10991: mtl_system_items msi,
10992: mtl_unit_transactions mut,
10993: mtl_transaction_lot_numbers mtln,
10994: mtl_material_transactions mmt,
10995: mtl_secondary_inventories msei,
10996: hr_all_organization_units haou
10997: WHERE mmt.transaction_id = p_mtl_txn_id