APPS.WSM_JOBCOSTING_GRP dependencies on WSM_SM_RESULTING_JOBS

Line 124: wsm_sm_resulting_jobs WSRJ,

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,
124: wsm_sm_resulting_jobs WSRJ,
125: mtl_system_items MSI,
126: org_acct_periods OAP,
127: mtl_transaction_types MTT
128: WHERE WSMT.transaction_id = p_txn_id

Line 209: FROM WSM_SM_RESULTING_JOBS

205: SELECT wip_entity_id,
206: starting_operation_seq_num
207: INTO l_rep_we_id,
208: l_op_seq_num
209: FROM WSM_SM_RESULTING_JOBS
210: WHERE transaction_id = p_txn_id;
211:
212: l_stmt_num := 7;
213:

Line 260: wsm_sm_resulting_jobs WSRJ

256: (SELECT round(decode(sign(nvl(wro1.quantity_issued, 0) - nvl(wro1.quantity_relieved, 0)), 1, 1, 0)
257: *(nvl(wro1.quantity_issued,0) - nvl(wro1.quantity_relieved, 0))
258: * WSRJ.start_quantity/l_avail_qty, 6)
259: FROM wip_requirement_operations wro1,
260: wsm_sm_resulting_jobs WSRJ
261: WHERE wro1.wip_entity_id = l_rep_we_id
262: AND wro1.inventory_item_id = wro.inventory_item_id
263: AND wro1.organization_id = wro.organization_id
264: AND wro1.operation_seq_num = wro.operation_seq_num

Line 268: from wsm_sm_resulting_jobs

264: AND wro1.operation_seq_num = wro.operation_seq_num
265: AND WSRJ.wip_entity_id = wro.wip_entity_id
266: AND WSRJ.transaction_id = p_txn_id) -- Fix for bug #3086120
267: WHERE wro.wip_entity_id in (select wip_entity_id
268: from wsm_sm_resulting_jobs
269: where transaction_id = p_txn_id
270: and wip_entity_id <> l_rep_we_id)
271: AND not exists (select 'obsolete operation'
272: from wip_operations wo

Line 284: FROM wsm_sm_resulting_jobs WSRJ

280: -- Update the representative job, may or may not be present in resulting
281: BEGIN
282: SELECT WSRJ.start_quantity
283: INTO l_result_qty
284: FROM wsm_sm_resulting_jobs WSRJ
285: WHERE WSRJ.transaction_id = p_txn_id
286: AND WSRJ.wip_entity_id in (select wip_entity_id
287: from wsm_sm_starting_jobs
288: where transaction_id = p_txn_id