[Home] [Help]
469: /***************************************************************
470: * Insert header rows for each schedule in to allocation
471: **************************************************************/
472: where_num := 210;
473: INSERT INTO wip_txn_allocations
474: (transaction_id, repetitive_schedule_id,
475: organization_id, last_update_date,
476: last_updated_by, creation_date,
477: created_by, last_update_login,
570: DECODE((max(cce.cost_element_id) - min(cce.cost_element_id)),
571: 0, max(cce.cost_element_id), NULL)
572: from
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
662: DECODE((max(cce.cost_element_id) - min(cce.cost_element_id)),
663: 0, max(cce.cost_element_id), NULL)
664: from
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
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: WHERE i.group_id = l_group_id
751: AND i.transaction_id = alloc.transaction_id
752: AND i.line_id IS NOT NULL);*/
753:
788: AND (wpb.wip_entity_id, wpb.repetitive_schedule_id) IN
789: (SELECT i.wip_entity_id,
790: alloc.repetitive_schedule_id
791: FROM WIP_COST_TXN_INTERFACE i,
792: WIP_TXN_ALLOCATIONS alloc
793: WHERE i.group_id = l_group_id
794: AND i.transaction_id = alloc.transaction_id
795: AND i.line_id IS NOT NULL);
796:
858: AND (wpb.wip_entity_id, wpb.repetitive_schedule_id) IN
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