DBA Data[Home] [Help]

APPS.CSTPWPVR dependencies on WIP_DISCRETE_JOBS

Line 80: wip_discrete_jobs j

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
84: AND j.wip_entity_id = b.wip_entity_id

Line 217: wip_discrete_jobs wdj,

213: DECODE((max(cce.cost_element_id) - min(cce.cost_element_id)),
214: 0, max(cce.cost_element_id), NULL)
215: from
216: wip_cost_txn_interface wcti,
217: wip_discrete_jobs wdj,
218: wip_period_balances wpb,
219: cst_cost_elements cce
220: WHERE wcti.group_id = l_group_id
221: AND wcti.line_id IS NULL

Line 302: wip_discrete_jobs wdj,

298: DECODE((max(cce.cost_element_id) - min(cce.cost_element_id)),
299: 0, max(cce.cost_element_id), NULL)
300: from
301: wip_cost_txn_interface wcti,
302: wip_discrete_jobs wdj,
303: wip_period_balances wpb,
304: cst_cost_elements cce
305: WHERE wcti.group_id = l_group_id
306: AND wcti.line_id IS NULL