DBA Data[Home] [Help]

APPS.CSTPWPVR dependencies on WIP_DISCRETE_JOBS

Line 79: wip_discrete_jobs j

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) */
82: AND b.acct_period_id = i_close_period_id
83: AND j.wip_entity_id = b.wip_entity_id

Line 189: wip_discrete_jobs wdj

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
192: AND wcti.wip_entity_id = wpb.wip_entity_id
193: AND wcti.acct_period_id >= wpb.acct_period_id

Line 274: wip_discrete_jobs wdj

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
277: AND wcti.wip_entity_id = wpb.wip_entity_id
278: AND wcti.acct_period_id >= wpb.acct_period_id