APPS.WIP_AUTOLOTPROC_PRIV dependencies on MTL_SYSTEM_ITEMS

Line 288: mtl_system_items_kfv msi,

284: msi.serial_number_control_code,
285: msi.lot_control_code,
286: mmtt.revision
287: from mtl_material_transactions_temp mmtt,
288: mtl_system_items_kfv msi,
289: mtl_transaction_lots_temp mtlt
290: where mmtt.completion_transaction_id = p_cplTxnID
291: and mmtt.transaction_action_id in (wip_constants.isscomp_action, wip_constants.retcomp_action,
292: wip_constants.issnegc_action, wip_constants.retnegc_action)

Line 331: mtl_system_items_kfv msi,

327: msi.serial_number_control_code,
328: msi.lot_control_code,
329: mmtt.revision
330: from mtl_material_transactions_temp mmtt,
331: mtl_system_items_kfv msi,
332: mtl_transaction_lots_temp mtlt
333: where mmtt.move_transaction_id = p_movTxnID
334: and mmtt.transaction_action_id in (wip_constants.isscomp_action, wip_constants.retcomp_action,
335: wip_constants.issnegc_action, wip_constants.retnegc_action)

Line 658: mtl_system_items_kfv msi,

654: mti.revision,
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)

Line 706: mtl_system_items_kfv msi,

702: mti.revision,
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))

Line 753: mtl_system_items_kfv msi,

749: msi.serial_number_control_code,
750: msi.lot_control_code,
751: mti.revision
752: from mtl_material_transactions_temp mti,
753: mtl_system_items_kfv msi,
754: mtl_transaction_lots_temp mtlt
755: where mti.move_transaction_id = p_movTxnID
756: and mti.transaction_action_id in (wip_constants.isscomp_action, wip_constants.retcomp_action,
757: wip_constants.issnegc_action, wip_constants.retnegc_action)

Line 1722: from mtl_system_items

1718: end if;
1719:
1720: select lot_control_code, serial_number_control_code
1721: into l_lotControlCode, l_serialControlCode
1722: from mtl_system_items
1723: where inventory_item_id = l_item.inventory_item_id
1724: and organization_id = p_orgID;
1725:
1726: --if under serial control, we can not derive lots