[Home] [Help]
75: i_close_period_id, 5,
76: oa.schedule_close_date, l_group_id,
77: NULL
78: FROM wip_period_balances b,
79: org_acct_periods oa,
80: wip_discrete_jobs j
81: WHERE b.class_type IN (4,6) -- Bug #2357983.
82: /* modified for EAM (class_type = 6); modified for OSFM (class_type = 7) */
83: AND b.acct_period_id = i_close_period_id
436: i_close_period_id, 5,
437: oa.schedule_close_date, l_group_id,
438: wri.line_id
439: FROM wip_repetitive_items wri,
440: org_acct_periods oa
441: WHERE oa.organization_id = i_org_id
442: AND oa.acct_period_id = i_close_period_id
443: AND (wri.wip_entity_id, wri.line_id) IN
444: (SELECT s.wip_entity_id, s.line_id
443: AND (wri.wip_entity_id, wri.line_id) IN
444: (SELECT s.wip_entity_id, s.line_id
445: FROM wip_period_balances b,
446: wip_repetitive_schedules s,
447: org_acct_periods a
448: WHERE b.acct_period_id = i_close_period_id
449: /* only if the schedule has a balance row in this period */
450: AND b.organization_id = i_org_id
451: AND b.class_type = 2
483: 0, 0
484: FROM wip_cost_txn_interface i,
485: wip_period_balances b,
486: wip_repetitive_schedules s,
487: org_acct_periods a
488: WHERE i.group_id = l_group_id
489: AND i.line_id IS NOT NULL
490: AND S.WIP_ENTITY_ID = I.WIP_ENTITY_ID
491: AND s.line_id = i.line_id
860: alloc.repetitive_schedule_id
861: FROM WIP_COST_TXN_INTERFACE i,
862: WIP_TXN_ALLOCATIONS alloc,
863: WIP_REPETITIVE_SCHEDULES s,
864: ORG_ACCT_PERIODS oap
865: WHERE i.group_id = l_group_id
866: AND i.line_id IS NOT NULL
867: AND i.transaction_id = alloc.transaction_id
868: AND alloc.repetitive_schedule_id = s.repetitive_schedule_id