APPS.CSTPWPVR dependencies on WIP_PERIOD_BALANCES

Line 77: FROM wip_period_balances b,

73: i_org_id, b.wip_entity_id,
74: i_close_period_id, 5,
75: oa.schedule_close_date, l_group_id,
76: NULL
77: FROM wip_period_balances b,
78: org_acct_periods oa,
79: wip_discrete_jobs j
80: WHERE b.class_type IN (4,6) -- Bug #2357983.
81: /* modified for EAM (class_type = 6); modified for OSFM (class_type = 7) */

Line 187: wip_period_balances wpb,

183: DECODE((max(cce.cost_element_id) - min(cce.cost_element_id)),
184: 0, max(cce.cost_element_id), NULL)
185: from
186: wip_cost_txn_interface wcti,
187: wip_period_balances wpb,
188: cst_cost_elements cce,
189: wip_discrete_jobs wdj
190: WHERE wcti.group_id = l_group_id
191: AND wcti.line_id IS NULL

Line 272: wip_period_balances wpb,

268: DECODE((max(cce.cost_element_id) - min(cce.cost_element_id)),
269: 0, max(cce.cost_element_id), NULL)
270: from
271: wip_cost_txn_interface wcti,
272: wip_period_balances wpb,
273: cst_cost_elements cce,
274: wip_discrete_jobs wdj
275: WHERE wcti.group_id = l_group_id
276: AND wcti.line_id IS NULL

Line 298: UPDATE WIP_PERIOD_BALANCES wpb

294: /****************************************************************
295: * Update variance columns for expense/eam jobs
296: ****************************************************************/
297: where_num := 160;
298: UPDATE WIP_PERIOD_BALANCES wpb
299: SET (LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,
300: PL_MATERIAL_VAR, PL_MATERIAL_OVERHEAD_VAR,
301: PL_RESOURCE_VAR, PL_OUTSIDE_PROCESSING_VAR,
302: PL_OVERHEAD_VAR, TL_MATERIAL_VAR,

Line 336: FROM WIP_PERIOD_BALANCES wpb2

332: - decode(acct_period_id,i_close_period_id,0,NVL(TL_OUTSIDE_PROCESSING_VAR,0))),
333: SUM( NVL(TL_OVERHEAD_IN,0)
334: - NVL(TL_OVERHEAD_OUT,0)
335: - decode(acct_period_id,i_close_period_id,0,NVL(TL_OVERHEAD_VAR,0)))
336: FROM WIP_PERIOD_BALANCES wpb2
337: WHERE wpb2.wip_entity_id = wpb.wip_entity_id
338: AND wpb2.acct_period_id <= wpb.acct_period_id)
339: /* sum across all periods */
340: WHERE (wpb.acct_period_id, wpb.wip_entity_id) IN

Line 376: FROM wip_period_balances b,

372: WHERE oa.organization_id = i_org_id
373: AND oa.acct_period_id = i_close_period_id
374: AND (wri.wip_entity_id, wri.line_id) IN
375: (SELECT s.wip_entity_id, s.line_id
376: FROM wip_period_balances b,
377: wip_repetitive_schedules s,
378: org_acct_periods a
379: WHERE b.acct_period_id = i_close_period_id
380: /* only if the schedule has a balance row in this period */

Line 416: wip_period_balances b,

412: b.organization_id,
413: SYSDATE, i_user_id, SYSDATE, i_user_id, i_login_id,
414: 0, 0
415: FROM wip_cost_txn_interface i,
416: wip_period_balances b,
417: wip_repetitive_schedules s,
418: org_acct_periods a
419: WHERE i.group_id = l_group_id
420: AND i.line_id IS NOT NULL

Line 506: wip_period_balances wpb,

502: 0, max(cce.cost_element_id), NULL)
503: from
504: wip_cost_txn_interface wcti,
505: wip_txn_allocations alloc,
506: wip_period_balances wpb,
507: cst_cost_elements cce,
508: wip_repetitive_schedules wrs
509: WHERE wcti.group_id = l_group_id
510: AND wcti.line_id IS NOT NULL

Line 598: wip_period_balances wpb,

594: 0, max(cce.cost_element_id), NULL)
595: from
596: wip_cost_txn_interface wcti,
597: wip_txn_allocations alloc,
598: wip_period_balances wpb,
599: cst_cost_elements cce,
600: wip_repetitive_schedules wrs
601: WHERE wcti.group_id = l_group_id
602: AND wcti.line_id IS NOT NULL

Line 629: UPDATE WIP_PERIOD_BALANCES wpb

625: /*--------------------------------------------------------------------+
626: | Update variance columns for schedules
627: +---------------------------------------------------------------*/
628: where_num := 260;
629: UPDATE WIP_PERIOD_BALANCES wpb
630: SET (LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,
631: PL_MATERIAL_VAR, PL_MATERIAL_OVERHEAD_VAR,
632: PL_RESOURCE_VAR, PL_OUTSIDE_PROCESSING_VAR,
633: PL_OVERHEAD_VAR, TL_MATERIAL_VAR,

Line 667: FROM WIP_PERIOD_BALANCES wpb2

663: - decode(acct_period_id,i_close_period_id,0,NVL(TL_OUTSIDE_PROCESSING_VAR,0))),
664: SUM( NVL(TL_OVERHEAD_IN,0)
665: - NVL(TL_OVERHEAD_OUT,0)
666: - decode(acct_period_id,i_close_period_id,0,NVL(TL_OVERHEAD_VAR,0)))
667: FROM WIP_PERIOD_BALANCES wpb2
668: WHERE wpb2.wip_entity_id = wpb.wip_entity_id
669: AND wpb2.acct_period_id <= wpb.acct_period_id
670: /* sum across all acct periods */
671: AND wpb2.organization_id = wpb.organization_id

Line 742: DELETE FROM wip_period_balances wpb

738: * completion date
739: **************************************************************/
740: where_num := 600;
741:
742: DELETE FROM wip_period_balances wpb
743: WHERE wpb.acct_period_id > i_close_period_id
744: AND wpb.organization_id = i_org_id
745: AND (wpb.wip_entity_id, wpb.repetitive_schedule_id) IN
746: (SELECT i.wip_entity_id,