DBA Data[Home] [Help]

APPS.WIP_AUTOLOTPROC_PRIV dependencies on MTL_SYSTEM_ITEMS_KFV

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)