eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSM_JOBCOSTING_GRP dependencies on WSMPCNST

Line 108: decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, 40,

104: sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.LOGIN_ID,
105: sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_REQUEST_ID,
106: FND_GLOBAL.PROG_APPL_ID, FND_GLOBAL.CONC_PROGRAM_ID, sysdate,
107: WSRJ.primary_item_id, WSMT.organization_id, MTT.transaction_type_id,
108: decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, 40,
109: WSMPCNST.MERGE, 41,
110: WSMPCNST.BONUS, 42,
111: WSMPCNST.UPDATE_QUANTITY, 43, 0),
112: MTT.transaction_source_type_id,

Line 109: WSMPCNST.MERGE, 41,

105: sysdate, FND_GLOBAL.USER_ID, FND_GLOBAL.CONC_REQUEST_ID,
106: FND_GLOBAL.PROG_APPL_ID, FND_GLOBAL.CONC_PROGRAM_ID, sysdate,
107: WSRJ.primary_item_id, WSMT.organization_id, MTT.transaction_type_id,
108: decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, 40,
109: WSMPCNST.MERGE, 41,
110: WSMPCNST.BONUS, 42,
111: WSMPCNST.UPDATE_QUANTITY, 43, 0),
112: MTT.transaction_source_type_id,
113: decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, WSSJ.wip_entity_id, WSRJ.wip_entity_id),

Line 110: WSMPCNST.BONUS, 42,

106: FND_GLOBAL.PROG_APPL_ID, FND_GLOBAL.CONC_PROGRAM_ID, sysdate,
107: WSRJ.primary_item_id, WSMT.organization_id, MTT.transaction_type_id,
108: decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, 40,
109: WSMPCNST.MERGE, 41,
110: WSMPCNST.BONUS, 42,
111: WSMPCNST.UPDATE_QUANTITY, 43, 0),
112: MTT.transaction_source_type_id,
113: decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, WSSJ.wip_entity_id, WSRJ.wip_entity_id),
114: decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, WSSJ.wip_entity_name, WSRJ.wip_entity_name),

Line 111: WSMPCNST.UPDATE_QUANTITY, 43, 0),

107: WSRJ.primary_item_id, WSMT.organization_id, MTT.transaction_type_id,
108: decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, 40,
109: WSMPCNST.MERGE, 41,
110: WSMPCNST.BONUS, 42,
111: WSMPCNST.UPDATE_QUANTITY, 43, 0),
112: MTT.transaction_source_type_id,
113: decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, WSSJ.wip_entity_id, WSRJ.wip_entity_id),
114: decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, WSSJ.wip_entity_name, WSRJ.wip_entity_name),
115: decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, WSSJ.available_quantity, WSRJ.start_quantity),

Line 113: decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, WSSJ.wip_entity_id, WSRJ.wip_entity_id),

109: WSMPCNST.MERGE, 41,
110: WSMPCNST.BONUS, 42,
111: WSMPCNST.UPDATE_QUANTITY, 43, 0),
112: MTT.transaction_source_type_id,
113: decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, WSSJ.wip_entity_id, WSRJ.wip_entity_id),
114: decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, WSSJ.wip_entity_name, WSRJ.wip_entity_name),
115: decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, WSSJ.available_quantity, WSRJ.start_quantity),
116: decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, WSSJ.available_quantity, WSRJ.start_quantity),
117: MSI.primary_uom_code,

Line 114: decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, WSSJ.wip_entity_name, WSRJ.wip_entity_name),

110: WSMPCNST.BONUS, 42,
111: WSMPCNST.UPDATE_QUANTITY, 43, 0),
112: MTT.transaction_source_type_id,
113: decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, WSSJ.wip_entity_id, WSRJ.wip_entity_id),
114: decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, WSSJ.wip_entity_name, WSRJ.wip_entity_name),
115: decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, WSSJ.available_quantity, WSRJ.start_quantity),
116: decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, WSSJ.available_quantity, WSRJ.start_quantity),
117: MSI.primary_uom_code,
118: WSMT.transaction_date, WSMT.transaction_id,

Line 115: decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, WSSJ.available_quantity, WSRJ.start_quantity),

111: WSMPCNST.UPDATE_QUANTITY, 43, 0),
112: MTT.transaction_source_type_id,
113: decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, WSSJ.wip_entity_id, WSRJ.wip_entity_id),
114: decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, WSSJ.wip_entity_name, WSRJ.wip_entity_name),
115: decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, WSSJ.available_quantity, WSRJ.start_quantity),
116: decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, WSSJ.available_quantity, WSRJ.start_quantity),
117: MSI.primary_uom_code,
118: WSMT.transaction_date, WSMT.transaction_id,
119: decode(WSMT.transaction_type_id, WSMPCNST.BONUS, WSRJ.starting_operation_seq_num, WSSJ.operation_seq_num),

Line 116: decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, WSSJ.available_quantity, WSRJ.start_quantity),

112: MTT.transaction_source_type_id,
113: decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, WSSJ.wip_entity_id, WSRJ.wip_entity_id),
114: decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, WSSJ.wip_entity_name, WSRJ.wip_entity_name),
115: decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, WSSJ.available_quantity, WSRJ.start_quantity),
116: decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, WSSJ.available_quantity, WSRJ.start_quantity),
117: MSI.primary_uom_code,
118: WSMT.transaction_date, WSMT.transaction_id,
119: decode(WSMT.transaction_type_id, WSMPCNST.BONUS, WSRJ.starting_operation_seq_num, WSSJ.operation_seq_num),
120: OAP.acct_period_id, 'N',

Line 119: decode(WSMT.transaction_type_id, WSMPCNST.BONUS, WSRJ.starting_operation_seq_num, WSSJ.operation_seq_num),

115: decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, WSSJ.available_quantity, WSRJ.start_quantity),
116: decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, WSSJ.available_quantity, WSRJ.start_quantity),
117: MSI.primary_uom_code,
118: WSMT.transaction_date, WSMT.transaction_id,
119: decode(WSMT.transaction_type_id, WSMPCNST.BONUS, WSRJ.starting_operation_seq_num, WSSJ.operation_seq_num),
120: OAP.acct_period_id, 'N',
121: decode(l_wms_org, 'Y', l_def_cost_grp_id, NULL)
122: FROM wsm_sm_starting_jobs WSSJ,
123: wsm_split_merge_transactions WSMT,

Line 129: AND WSMT.transaction_id = decode(WSMT.transaction_type_id, WSMPCNST.BONUS, WSMT.transaction_id,

125: mtl_system_items MSI,
126: org_acct_periods OAP,
127: mtl_transaction_types MTT
128: WHERE WSMT.transaction_id = p_txn_id
129: AND WSMT.transaction_id = decode(WSMT.transaction_type_id, WSMPCNST.BONUS, WSMT.transaction_id,
130: WSSJ.transaction_id)
131: AND WSMT.transaction_id = WSRJ.transaction_id
132: AND WSRJ.primary_item_id = MSI.inventory_item_id
133: AND WSRJ.organization_id = MSI.organization_id

Line 136: AND MTT.transaction_action_id IN(decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, 40,

132: AND WSRJ.primary_item_id = MSI.inventory_item_id
133: AND WSRJ.organization_id = MSI.organization_id
134: AND WSMT.organization_id = OAP.organization_id
135: AND trunc(WSMT.transaction_date) between period_start_date and schedule_close_date
136: AND MTT.transaction_action_id IN(decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, 40,
137: WSMPCNST.MERGE, 41,
138: WSMPCNST.BONUS, 42,
139: WSMPCNST.UPDATE_QUANTITY, 43, 0))
140: AND MTT.transaction_source_type_id = 5

Line 137: WSMPCNST.MERGE, 41,

133: AND WSRJ.organization_id = MSI.organization_id
134: AND WSMT.organization_id = OAP.organization_id
135: AND trunc(WSMT.transaction_date) between period_start_date and schedule_close_date
136: AND MTT.transaction_action_id IN(decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, 40,
137: WSMPCNST.MERGE, 41,
138: WSMPCNST.BONUS, 42,
139: WSMPCNST.UPDATE_QUANTITY, 43, 0))
140: AND MTT.transaction_source_type_id = 5
141: AND rownum = 1; --This picks up only 1 row for Split/Merge

Line 138: WSMPCNST.BONUS, 42,

134: AND WSMT.organization_id = OAP.organization_id
135: AND trunc(WSMT.transaction_date) between period_start_date and schedule_close_date
136: AND MTT.transaction_action_id IN(decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, 40,
137: WSMPCNST.MERGE, 41,
138: WSMPCNST.BONUS, 42,
139: WSMPCNST.UPDATE_QUANTITY, 43, 0))
140: AND MTT.transaction_source_type_id = 5
141: AND rownum = 1; --This picks up only 1 row for Split/Merge
142:

Line 139: WSMPCNST.UPDATE_QUANTITY, 43, 0))

135: AND trunc(WSMT.transaction_date) between period_start_date and schedule_close_date
136: AND MTT.transaction_action_id IN(decode(WSMT.transaction_type_id, WSMPCNST.SPLIT, 40,
137: WSMPCNST.MERGE, 41,
138: WSMPCNST.BONUS, 42,
139: WSMPCNST.UPDATE_QUANTITY, 43, 0))
140: AND MTT.transaction_source_type_id = 5
141: AND rownum = 1; --This picks up only 1 row for Split/Merge
142:
143: fnd_file.put_line(fnd_file.log, 'Records inserted into MMT ='||SQL%ROWCOUNT);

Line 201: IF (p_txn_type = WSMPCNST.BONUS) THEN

197: BEGIN
198:
199: l_stmt_num := 3;
200:
201: IF (p_txn_type = WSMPCNST.BONUS) THEN
202:
203: l_stmt_num := 5;
204:
205: SELECT wip_entity_id,

Line 233: IF p_txn_type IN (WSMPCNST.SPLIT, WSMPCNST.MERGE) THEN --This has been added to improve performance

229: FROM WSM_SM_STARTING_JOBS
230: WHERE transaction_id = p_txn_id
231: AND representative_flag = 'Y';
232:
233: IF p_txn_type IN (WSMPCNST.SPLIT, WSMPCNST.MERGE) THEN --This has been added to improve performance
234: -- as such the following stmts wont update anything for Upd Qty
235: l_stmt_num := 20;
236: -- Update the non-representative starting jobs
237: UPDATE wip_requirement_operations wro