DBA Data[Home] [Help]

APPS.WSM_SERIAL_SUPPORT_PVT dependencies on WIP_SERIAL_MOVE_TRANSACTIONS

Line 4747: FROM WIP_SERIAL_MOVE_TRANSACTIONS WSMT

4743: SELECT MSN.serial_number,
4744: MSN.gen_object_id
4745: FROM MTL_SERIAL_NUMBERS MSN
4746: WHERE MSN.SERIAL_NUMBER IN (select wsmt.assembly_serial_number
4747: FROM WIP_SERIAL_MOVE_TRANSACTIONS WSMT
4748: WHERE WSMT.transaction_id = v_txn_id
4749: )
4750: AND MSN.current_organization_id = p_organization_id
4751: AND MSN.inventory_item_id = p_inventory_item_id

Line 4760: FROM WIP_SERIAL_MOVE_TRANSACTIONS WSMT

4756: SELECT MSN.serial_number,
4757: MSN.gen_object_id
4758: FROM MTL_SERIAL_NUMBERS MSN
4759: WHERE MSN.SERIAL_NUMBER IN (select wsmt.assembly_serial_number
4760: FROM WIP_SERIAL_MOVE_TRANSACTIONS WSMT
4761: WHERE WSMT.transaction_id = v_txn_id
4762: )
4763: AND MSN.current_organization_id = p_organization_id
4764: AND MSN.inventory_item_id = p_inventory_item_id

Line 8258: wip_serial_move_transactions wsmt,

8254: msn.current_organization_id,
8255: wmt.wip_entity_id
8256: from mtl_serial_numbers msn,
8257: wip_move_transactions wmt,
8258: wip_serial_move_transactions wsmt,
8259: wsm_lot_based_jobs wlbj
8260: where wmt.transaction_id in (p_move_txn_id, p_scrap_txn_id)
8261: and wmt.wip_entity_id = wlbj.wip_entity_id
8262: and wmt.transaction_id = wsmt.transaction_id