APPS.WIP_AUTOLOTPROC_PRIV dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 659: mtl_transaction_lots_interface mtli

655: mti.move_transaction_id,
656: mti.completion_transaction_id
657: from mtl_transactions_interface mti,
658: mtl_system_items_kfv msi,
659: mtl_transaction_lots_interface mtli
660: where mti.transaction_header_id = p_txnHdrID
661: and mti.transaction_action_id in (wip_constants.isscomp_action, wip_constants.retcomp_action,
662: wip_constants.issnegc_action, wip_constants.retnegc_action)
663: and mti.inventory_item_id = msi.inventory_item_id

Line 707: mtl_transaction_lots_interface mtli

703: mti.move_transaction_id,
704: mti.completion_transaction_id
705: from mtl_transactions_interface mti,
706: mtl_system_items_kfv msi,
707: mtl_transaction_lots_interface mtli
708: where mti.transaction_header_id = p_txnHdrID
709: and ( mti.completion_transaction_id = p_cplTxnID
710: or mti.move_transaction_id in (p_movTxnID, p_childMovTxnID))
711: and mti.transaction_action_id in (wip_constants.isscomp_action, wip_constants.retcomp_action,

Line 974: insert into mtl_transaction_lots_interface

970: while(l_compObj.getNextLot(l_lot)) loop
971: if (l_logLevel <= wip_constants.full_logging) then
972: wip_logger.log('start inner loop2', l_returnStatus);
973: end if;
974: insert into mtl_transaction_lots_interface
975: (transaction_interface_id,
976: last_update_date,
977: last_updated_by,
978: creation_date,

Line 2247: from mtl_transaction_lots_interface

2243: begin
2244:
2245: select sum(abs(nvl(transaction_quantity, 0)))
2246: into l_qty
2247: from mtl_transaction_lots_interface
2248: where transaction_interface_id in
2249: (select transaction_interface_id
2250: from mtl_transactions_interface
2251: where inventory_item_id = p_inventory_item_id