APPS.WIP_AUTOLOTPROC_PRIV dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 660: mtl_transaction_lots_interface mtli

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,
663: wip_constants.issnegc_action, wip_constants.retnegc_action)
664: and mti.inventory_item_id = msi.inventory_item_id

Line 708: mtl_transaction_lots_interface mtli

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
711: or mti.move_transaction_id in (p_movTxnID, p_childMovTxnID))
712: and mti.transaction_action_id in (wip_constants.isscomp_action, wip_constants.retcomp_action,

Line 980: insert into mtl_transaction_lots_interface

976: while(l_compObj.getNextLot(l_lot)) loop
977: if (l_logLevel <= wip_constants.full_logging) then
978: wip_logger.log('start inner loop2', l_returnStatus);
979: end if;
980: insert into mtl_transaction_lots_interface
981: (transaction_interface_id,
982: last_update_date,
983: last_updated_by,
984: creation_date,

Line 2318: from mtl_transaction_lots_interface

2314: begin
2315:
2316: select sum(abs(nvl(transaction_quantity, 0)))
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