[Home] [Help]
540: +--------------*/
541:
542: var_user_id := fnd_profile.value('USER_ID');
543: /*-----------------------------------------------+
544: | Insert subinventories into msc_sub_inventories |
545: | that are defined after options are defined |
546: +-----------------------------------------------*/
547: BEGIN
548:
545: | that are defined after options are defined |
546: +-----------------------------------------------*/
547: BEGIN
548:
549: INSERT INTO MSC_SUB_INVENTORIES
550: (SUB_INVENTORY_CODE,
551: ORGANIZATION_ID,
552: SR_INSTANCE_ID,
553: PLAN_ID,
566: -1,
567: SYSDATE,
568: 1,
569: msi.netting_type
570: FROM msc_sub_inventories msi,
571: msc_plan_organizations mpo
572: WHERE NOT EXISTS
573: (SELECT NULL
574: FROM MSC_SUB_INVENTORIES SUB
570: FROM msc_sub_inventories msi,
571: msc_plan_organizations mpo
572: WHERE NOT EXISTS
573: (SELECT NULL
574: FROM MSC_SUB_INVENTORIES SUB
575: WHERE SUB.ORGANIZATION_ID = mpo.organization_id
576: AND sub.sr_instance_id = mpo.sr_instance_id
577: AND SUB.plan_id = mpo.plan_id
578: AND SUB.sub_inventory_code = msi.sub_inventory_code)
586: -- of sub inventories in original plan as well.
587: -- --------------------------------------------
588: --if v_plan_id <> arg_plan_id THEN
589: if v_plan_id <> v_new_plan_id THEN
590: INSERT INTO MSC_SUB_INVENTORIES
591: (SUB_INVENTORY_CODE,
592: ORGANIZATION_ID,
593: SR_INSTANCE_ID,
594: PLAN_ID,
608: -1,
609: SYSDATE,
610: 1,
611: msi.netting_type
612: FROM msc_sub_inventories msi,
613: msc_plan_organizations mpo
614: WHERE NOT EXISTS
615: (SELECT NULL
616: FROM msc_sub_inventories sub
612: FROM msc_sub_inventories msi,
613: msc_plan_organizations mpo
614: WHERE NOT EXISTS
615: (SELECT NULL
616: FROM msc_sub_inventories sub
617: WHERE sub.organization_id = mpo.organization_id
618: AND sub.sr_instance_id = mpo.sr_instance_id
619: AND sub.plan_id = mpo.plan_id
620: AND sub.sub_inventory_code = msi.sub_inventory_code)
1587: program_id = v_temp_plan_name_cur.program_id,
1588: program_update_date = v_temp_plan_name_cur.program_update_date
1589: Where plan_id = p_temp_plan_id;
1590:
1591: Update MSC_SUB_INVENTORIES
1592: set last_updated_by = v_temp_plan_name_cur.last_updated_by,
1593: last_update_date = v_temp_plan_name_cur.last_update_date,
1594: last_update_login = v_temp_plan_name_cur.last_update_login,
1595: request_id = v_temp_plan_name_cur.request_id,
1816: end if;
1817: End if; -- End Vrec_C1.request_id check
1818:
1819: /*-----------------------------------------------+
1820: | Insert subinventories into msc_sub_inventories |
1821: | that are defined after options are defined |
1822: +-----------------------------------------------*/
1823: if (arg_launch_scheduler <> DS_OLS_ONLY) then
1824: BEGIN
1821: | that are defined after options are defined |
1822: +-----------------------------------------------*/
1823: if (arg_launch_scheduler <> DS_OLS_ONLY) then
1824: BEGIN
1825: INSERT INTO MSC_SUB_INVENTORIES
1826: ( SUB_INVENTORY_CODE
1827: , ORGANIZATION_ID
1828: , SR_INSTANCE_ID
1829: , PLAN_ID
1844: , -1
1845: , SYSDATE
1846: , 1
1847: , msi.netting_type
1848: FROM msc_sub_inventories msi
1849: , msc_plan_organizations mpo
1850: WHERE NOT EXISTS (SELECT NULL
1851: FROM MSC_SUB_INVENTORIES SUB
1852: WHERE SUB.ORGANIZATION_ID = mpo.organization_id
1847: , msi.netting_type
1848: FROM msc_sub_inventories msi
1849: , msc_plan_organizations mpo
1850: WHERE NOT EXISTS (SELECT NULL
1851: FROM MSC_SUB_INVENTORIES SUB
1852: WHERE SUB.ORGANIZATION_ID = mpo.organization_id
1853: AND sub.sr_instance_id = mpo.sr_instance_id
1854: AND SUB.plan_id = mpo.plan_id
1855: AND SUB.sub_inventory_code = msi.sub_inventory_code)