DBA Data[Home] [Help]

APPS.CSTPWPVR dependencies on WIP_REPETITIVE_SCHEDULES

Line 446: wip_repetitive_schedules s,

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
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

Line 486: wip_repetitive_schedules s,

482: SYSDATE, i_user_id, SYSDATE, i_user_id, i_login_id,
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

Line 577: wip_repetitive_schedules wrs

573: wip_cost_txn_interface wcti,
574: wip_txn_allocations alloc,
575: wip_period_balances wpb,
576: cst_cost_elements cce,
577: wip_repetitive_schedules wrs
578: WHERE wcti.group_id = l_group_id
579: AND wcti.line_id IS NOT NULL
580: AND WRS.WIP_ENTITY_ID = WCTI.WIP_ENTITY_ID
581: AND wrs.line_id = wcti.line_id

Line 669: wip_repetitive_schedules wrs

665: wip_cost_txn_interface wcti,
666: wip_txn_allocations alloc,
667: wip_period_balances wpb,
668: cst_cost_elements cce,
669: wip_repetitive_schedules wrs
670: WHERE wcti.group_id = l_group_id
671: AND wcti.line_id IS NOT NULL
672: AND WRS.WIP_ENTITY_ID = WCTI.WIP_ENTITY_ID
673: AND wrs.line_id = wcti.line_id

Line 863: WIP_REPETITIVE_SCHEDULES s,

859: (SELECT i.wip_entity_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