DBA Data[Home] [Help]

APPS.CST_JOBCLOSEVAR_GRP dependencies on ORG_ACCT_PERIODS

Line 276: , org_acct_periods ocpf

272: wip_period_balances wpb,
273: wip_discrete_jobs wdj,
274: cst_cost_elements cce
275: --{BUG#13072387
276: , org_acct_periods ocpf
277: , org_acct_periods ocpt
278: --}
279: WHERE wcti.group_id = p_wcti_group_id
280: AND wcti.wip_entity_id = wpb.wip_entity_id

Line 277: , org_acct_periods ocpt

273: wip_discrete_jobs wdj,
274: cst_cost_elements cce
275: --{BUG#13072387
276: , org_acct_periods ocpf
277: , org_acct_periods ocpt
278: --}
279: WHERE wcti.group_id = p_wcti_group_id
280: AND wcti.wip_entity_id = wpb.wip_entity_id
281: AND wcti.wip_entity_id = wdj.wip_entity_id

Line 410: , org_acct_periods ocpf

406: wip_period_balances wpb,
407: wip_discrete_jobs wdj,
408: cst_cost_elements cce
409: --{BUG#13072387
410: , org_acct_periods ocpf
411: , org_acct_periods ocpt
412: --}
413: WHERE wcti.group_id = p_wcti_group_id
414: AND cce.cost_element_id <> 2

Line 411: , org_acct_periods ocpt

407: wip_discrete_jobs wdj,
408: cst_cost_elements cce
409: --{BUG#13072387
410: , org_acct_periods ocpf
411: , org_acct_periods ocpt
412: --}
413: WHERE wcti.group_id = p_wcti_group_id
414: AND cce.cost_element_id <> 2
415: AND wcti.wip_entity_id = wpb.wip_entity_id

Line 544: , org_acct_periods ocpf

540: wpb.acct_period_id,0,
541: NVL(tl_overhead_var,0)))
542: FROM wip_period_balances wpb2
543: --{BUG#13072387
544: , org_acct_periods ocpf
545: , org_acct_periods ocpt
546: --}
547: WHERE wpb2.wip_entity_id = wpb.wip_entity_id
548: --{

Line 545: , org_acct_periods ocpt

541: NVL(tl_overhead_var,0)))
542: FROM wip_period_balances wpb2
543: --{BUG#13072387
544: , org_acct_periods ocpf
545: , org_acct_periods ocpt
546: --}
547: WHERE wpb2.wip_entity_id = wpb.wip_entity_id
548: --{
549: --AND wpb2.acct_period_id <= wpb.acct_period_id

Line 644: org_acct_periods a

640: IN
641: (SELECT a.acct_period_id,
642: i.wip_entity_id
643: FROM wip_cost_txn_interface i,
644: org_acct_periods a
645: --{BUG#13072387
646: , org_acct_periods f
647: --}
648:

Line 646: , org_acct_periods f

642: i.wip_entity_id
643: FROM wip_cost_txn_interface i,
644: org_acct_periods a
645: --{BUG#13072387
646: , org_acct_periods f
647: --}
648:
649: WHERE i.group_id = p_wcti_group_id
650: --{