APPS.MSC_LAUNCH_PLAN_PK dependencies on MSC_PLAN_ORGANIZATIONS

Line 535: from msc_plan_organizations

531: +---------------------------------------*/
532: UPDATE msc_parameters
533: SET repetitive_anchor_date = TO_DATE(arg_anchor_date, 'YYYY/MM/DD HH24:MI:SS')
534: WHERE (organization_id,sr_instance_id) IN (select organization_id, sr_instance_id
535: from msc_plan_organizations
536: Where plan_id = v_plan_id);
537: COMMIT;
538: /*-------------+
539: | Get user id |

Line 571: msc_plan_organizations mpo

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
575: WHERE SUB.ORGANIZATION_ID = mpo.organization_id

Line 613: msc_plan_organizations mpo

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
617: WHERE sub.organization_id = mpo.organization_id

Line 1538: Update MSC_PLAN_ORGANIZATIONS

1534: = ( select compile_designator,organization_id,sr_instance_id
1535: from msc_plans
1536: where plan_id=p_temp_plan_id);
1537:
1538: Update MSC_PLAN_ORGANIZATIONS
1539: set plan_completion_date = v_temp_plan_name_cur.Plan_Completion_Date,
1540: last_updated_by = v_temp_plan_name_cur.last_updated_by,
1541: last_update_date = v_temp_plan_name_cur.last_update_date,
1542: last_update_login = v_temp_plan_name_cur.last_update_login,

Line 1849: , msc_plan_organizations mpo

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
1853: AND sub.sr_instance_id = mpo.sr_instance_id