DBA Data[Home] [Help]

APPS.CSI_ORDER_FULFILL_PUB dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 3580: mtl_transaction_lot_numbers mtln,

3576: mmt.transaction_action_id mtl_action_id,
3577: mmt.transaction_source_type_id mtl_source_type_id,
3578: mmt.transaction_source_id mtl_source_id
3579: FROM mtl_unit_transactions mut,
3580: mtl_transaction_lot_numbers mtln,
3581: mtl_material_transactions mmt,
3582: mtl_transaction_types mtt
3583: WHERE mut.serial_number = p_serial_number
3584: AND mut.inventory_item_id = p_item_id

Line 3718: mtl_transaction_lot_numbers mtln,

3714: UNION
3715: SELECT mut.serial_number,
3716: mut.inventory_item_id
3717: FROM mtl_material_transactions mmt,
3718: mtl_transaction_lot_numbers mtln,
3719: mtl_unit_transactions mut
3720: WHERE mmt.transaction_source_type_id = 5
3721: AND mmt.transaction_action_id = 1
3722: AND mmt.inventory_item_id = px_config_rec.sub_config_item_id

Line 9977: mtl_transaction_lot_numbers mtln,

9973: FROM oe_order_headers_all ooh,
9974: oe_order_lines_all ool,
9975: mtl_system_items msi,
9976: mtl_unit_transactions mut,
9977: mtl_transaction_lot_numbers mtln,
9978: mtl_material_transactions mmt,
9979: mtl_secondary_inventories msei,
9980: hr_all_organization_units haou
9981: WHERE mmt.transaction_id = p_mtl_txn_id