APPS.WSM_SERIAL_SUPPORT_GRP dependencies on WIP_CONSTANTS

Line 237: AND MMT.transaction_type_id IN (WIP_CONSTANTS.ISSCOMP_TYPE, -- 35 -- WIP Component Issue

233: WHERE MMT.organization_id = p_organization_id
234: AND MMT.move_transaction_id IN (l_move_txn_id,l_scrap_txn_id)
235: AND MMT.transaction_source_id = p_wip_entity_id
236: AND MMT.subinventory_code IS NOT NULL
237: AND MMT.transaction_type_id IN (WIP_CONSTANTS.ISSCOMP_TYPE, -- 35 -- WIP Component Issue
238: WIP_CONSTANTS.ISSNEGC_TYPE -- 38 -- Negative component issue
239: );
240:
241: -- Transaction types

Line 238: WIP_CONSTANTS.ISSNEGC_TYPE -- 38 -- Negative component issue

234: AND MMT.move_transaction_id IN (l_move_txn_id,l_scrap_txn_id)
235: AND MMT.transaction_source_id = p_wip_entity_id
236: AND MMT.subinventory_code IS NOT NULL
237: AND MMT.transaction_type_id IN (WIP_CONSTANTS.ISSCOMP_TYPE, -- 35 -- WIP Component Issue
238: WIP_CONSTANTS.ISSNEGC_TYPE -- 38 -- Negative component issue
239: );
240:
241: -- Transaction types
242: -- ISSCOMP_TYPE CONSTANT NUMBER := 35; -- Components taken out of INV

Line 340: if p_move_txn_type = wip_constants.RET_TXN then

336: from dual;
337: */
338:
339: /* Have to be passed....
340: if p_move_txn_type = wip_constants.RET_TXN then
341: SELECT mtl_material_transactions_s.nextval
342: into p_compl_txn_id
343: from dual;
344: end if;

Line 494: decode(MMT.TRANSACTION_ACTION_ID,wip_constants.issnegc_action,

490: MMT.SUBINVENTORY_CODE,
491: MMT.LOCATOR_ID,
492: MMT.INVENTORY_ITEM_ID,
493: MMT.REVISION,
494: decode(MMT.TRANSACTION_ACTION_ID,wip_constants.issnegc_action,
495: wip_constants.retnegc_type,
496: wip_constants.retcomp_type
497:
498: ),

Line 495: wip_constants.retnegc_type,

491: MMT.LOCATOR_ID,
492: MMT.INVENTORY_ITEM_ID,
493: MMT.REVISION,
494: decode(MMT.TRANSACTION_ACTION_ID,wip_constants.issnegc_action,
495: wip_constants.retnegc_type,
496: wip_constants.retcomp_type
497:
498: ),
499: decode(MMT.TRANSACTION_ACTION_ID,wip_constants.issnegc_action,

Line 496: wip_constants.retcomp_type

492: MMT.INVENTORY_ITEM_ID,
493: MMT.REVISION,
494: decode(MMT.TRANSACTION_ACTION_ID,wip_constants.issnegc_action,
495: wip_constants.retnegc_type,
496: wip_constants.retcomp_type
497:
498: ),
499: decode(MMT.TRANSACTION_ACTION_ID,wip_constants.issnegc_action,
500: wip_constants.retnegc_action,

Line 499: decode(MMT.TRANSACTION_ACTION_ID,wip_constants.issnegc_action,

495: wip_constants.retnegc_type,
496: wip_constants.retcomp_type
497:
498: ),
499: decode(MMT.TRANSACTION_ACTION_ID,wip_constants.issnegc_action,
500: wip_constants.retnegc_action,
501: wip_constants.retcomp_action
502:
503: ),

Line 500: wip_constants.retnegc_action,

496: wip_constants.retcomp_type
497:
498: ),
499: decode(MMT.TRANSACTION_ACTION_ID,wip_constants.issnegc_action,
500: wip_constants.retnegc_action,
501: wip_constants.retcomp_action
502:
503: ),
504: MMT.TRANSACTION_SOURCE_TYPE_ID,

Line 501: wip_constants.retcomp_action

497:
498: ),
499: decode(MMT.TRANSACTION_ACTION_ID,wip_constants.issnegc_action,
500: wip_constants.retnegc_action,
501: wip_constants.retcomp_action
502:
503: ),
504: MMT.TRANSACTION_SOURCE_TYPE_ID,
505: MMT.TRANSACTION_SOURCE_ID,