DBA Data[Home] [Help]

APPS.WIP_AUTOLOTPROC_PRIV dependencies on MTL_TRANSACTIONS_INTERFACE

Line 658: from mtl_transactions_interface mti,

654: msi.lot_control_code,
655: mti.revision,
656: mti.move_transaction_id,
657: mti.completion_transaction_id
658: from mtl_transactions_interface mti,
659: mtl_system_items_kfv msi,
660: mtl_transaction_lots_interface mtli
661: where mti.transaction_header_id = p_txnHdrID
662: and mti.transaction_action_id in (wip_constants.isscomp_action, wip_constants.retcomp_action,

Line 706: from mtl_transactions_interface mti,

702: msi.lot_control_code,
703: mti.revision,
704: mti.move_transaction_id,
705: mti.completion_transaction_id
706: from mtl_transactions_interface mti,
707: mtl_system_items_kfv msi,
708: mtl_transaction_lots_interface mtli
709: where mti.transaction_header_id = p_txnHdrID
710: and ( mti.completion_transaction_id = p_cplTxnID

Line 2321: from mtl_transactions_interface

2317: into l_qty
2318: from mtl_transaction_lots_interface
2319: where transaction_interface_id in
2320: (select transaction_interface_id
2321: from mtl_transactions_interface
2322: where inventory_item_id = p_inventory_item_id
2323: and organization_id = p_organization_id
2324: and subinventory_code = p_sub_code
2325: and nvl(locator_id, -1) = nvl(p_locator_id, -1))