APPS.WSM_SERIAL_SUPPORT_PVT dependencies on WSM_LOT_MOVE_TXN_INTERFACE

Line 8171: -- Internal group id on wsm_lot_move_txn_interface will be passed

8167: END IF;
8168:
8169: END Insert_move_attr;
8170:
8171: -- Internal group id on wsm_lot_move_txn_interface will be passed
8172: Procedure Update_attr_move ( p_group_id IN NUMBER DEFAULT NULL, -- for interface...
8173: p_internal_group_id IN NUMBER DEFAULT NULL, -- for interface...
8174: p_move_txn_id IN NUMBER DEFAULT NULL, -- for forms...
8175: p_scrap_txn_id IN NUMBER DEFAULT NULL, -- for forms...

Line 8196: wsm_lot_move_txn_interface wlmti,

8192: msn.current_organization_id,
8193: wmt.wip_entity_id
8194: from mtl_serial_numbers msn,
8195: wip_move_transactions wmt,
8196: wsm_lot_move_txn_interface wlmti,
8197: wsm_lot_based_jobs wlbj
8198: where wlmti.group_id = p_group_id
8199: and wlmti.internal_group_id = p_internal_group_id
8200: and wlmti.wip_entity_id = wmt.wip_entity_id

Line 8217: wsm_lot_move_txn_interface wlmti,

8213: msn.inventory_item_id,
8214: msn.current_organization_id,
8215: wdj.wip_entity_id
8216: from mtl_serial_numbers msn,
8217: wsm_lot_move_txn_interface wlmti,
8218: wip_discrete_jobs wdj,
8219: wsm_lot_based_jobs wlbj
8220: where wlmti.group_id = p_group_id
8221: and wlmti.internal_group_id = p_internal_group_id

Line 8358: wsm_lot_move_txn_interface wlmti

8354: attribute15
8355: from wsm_serial_txn_interface wsti
8356: where header_id IN (Select wmt.transaction_id
8357: from wip_move_transactions wmt,
8358: wsm_lot_move_txn_interface wlmti
8359: where wlmti.group_id = p_group_id
8360: and wlmti.internal_group_id = p_internal_group_id
8361: and wlmti.wip_entity_id = wmt.wip_entity_id
8362: and wlmti.status = WIP_CONSTANTS.COMPLETED