DBA Data[Home] [Help]

APPS.WSM_SERIAL_SUPPORT_PVT dependencies on WIP_MOVE_TXN_INTERFACE

Line 7690: -- group id on wip_move_txn_interface will be passed

7686: );
7687:
7688: END validate_qty;
7689:
7690: -- group id on wip_move_txn_interface will be passed
7691: Procedure Insert_move_attr ( p_group_id IN NUMBER DEFAULT NULL,
7692: p_move_txn_id IN NUMBER DEFAULT NULL,
7693: p_scrap_txn_id IN NUMBER DEFAULT NULL,
7694: x_return_status OUT NOCOPY VARCHAR2,

Line 7932: wip_move_txn_interface WMTI

7928: sysdate ,
7929: null
7930: from wip_serial_move_interface WSMI,
7931: mtl_serial_numbers MSN,
7932: wip_move_txn_interface WMTI
7933: where WMTI.group_id = p_group_id
7934: and WMTI.transaction_id = WSMI.transaction_id
7935: and MSN.serial_number = WSMI.assembly_serial_number
7936: and MSN.current_organization_id = WMTI.organization_id

Line 8146: wip_move_txn_interface WMTI

8142: sysdate ,
8143: null
8144: from wip_serial_move_interface WSMI,
8145: mtl_serial_numbers MSN,
8146: wip_move_txn_interface WMTI
8147: where WMTI.transaction_id in (p_move_txn_id,p_scrap_txn_id)
8148: and WMTI.transaction_id = WSMI.transaction_id
8149: and MSN.serial_number = WSMI.assembly_serial_number
8150: and MSN.current_organization_id = WMTI.organization_id