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 659: mtl_system_items_kfv msi,

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,
663: wip_constants.issnegc_action, wip_constants.retnegc_action)

Line 707: mtl_system_items_kfv msi,

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
711: or mti.move_transaction_id in (p_movTxnID, p_childMovTxnID))

Line 754: mtl_system_items_kfv msi,

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

Line 1790: from mtl_system_items

1786: inv_cache.get_serial_tagged(p_orgID, -- Bug 9907143: added for serial tagging enhancement for SUN
1787: l_item.inventory_item_id,
1788: l_TxnTypeID) serial_tagged_code
1789: into l_lotControlCode, l_serialControlCode, l_serialTaggedCode
1790: from mtl_system_items
1791: where inventory_item_id = l_item.inventory_item_id
1792: and organization_id = p_orgID;
1793:
1794: --if under serial control, we can not derive lots