APPS.CSTPWPVR dependencies on WIP_TXN_ALLOCATIONS

Line 404: INSERT INTO wip_txn_allocations

400: /***************************************************************
401: * Insert header rows for each schedule in to allocation
402: **************************************************************/
403: where_num := 210;
404: INSERT INTO wip_txn_allocations
405: (transaction_id, repetitive_schedule_id,
406: organization_id, last_update_date,
407: last_updated_by, creation_date,
408: created_by, last_update_login,

Line 505: wip_txn_allocations alloc,

501: DECODE((max(cce.cost_element_id) - min(cce.cost_element_id)),
502: 0, max(cce.cost_element_id), NULL)
503: from
504: wip_cost_txn_interface wcti,
505: wip_txn_allocations alloc,
506: wip_period_balances wpb,
507: cst_cost_elements cce,
508: wip_repetitive_schedules wrs
509: WHERE wcti.group_id = l_group_id

Line 597: wip_txn_allocations alloc,

593: DECODE((max(cce.cost_element_id) - min(cce.cost_element_id)),
594: 0, max(cce.cost_element_id), NULL)
595: from
596: wip_cost_txn_interface wcti,
597: wip_txn_allocations alloc,
598: wip_period_balances wpb,
599: cst_cost_elements cce,
600: wip_repetitive_schedules wrs
601: WHERE wcti.group_id = l_group_id

Line 679: WIP_TXN_ALLOCATIONS alloc

675: AND (wpb.wip_entity_id, wpb.repetitive_schedule_id) IN
676: (SELECT i.wip_entity_id,
677: alloc.repetitive_schedule_id
678: FROM WIP_COST_TXN_INTERFACE i,
679: WIP_TXN_ALLOCATIONS alloc
680: WHERE i.group_id = l_group_id
681: AND i.transaction_id = alloc.transaction_id
682: AND i.line_id IS NOT NULL);
683:

Line 749: WIP_TXN_ALLOCATIONS alloc,

745: AND (wpb.wip_entity_id, wpb.repetitive_schedule_id) IN
746: (SELECT i.wip_entity_id,
747: alloc.repetitive_schedule_id
748: FROM WIP_COST_TXN_INTERFACE i,
749: WIP_TXN_ALLOCATIONS alloc,
750: WIP_REPETITIVE_SCHEDULES s,
751: ORG_ACCT_PERIODS oap
752: WHERE i.group_id = l_group_id
753: AND i.line_id IS NOT NULL