APPS.MSC_LAUNCH_PLAN_PK dependencies on MSC_PLAN_ORGANIZATIONS

Line 504: from msc_plan_organizations

500: +---------------------------------------*/
501: UPDATE msc_parameters
502: SET repetitive_anchor_date = TO_DATE(arg_anchor_date, 'YYYY/MM/DD HH24:MI:SS')
503: WHERE (organization_id,sr_instance_id) IN (select organization_id, sr_instance_id
504: from msc_plan_organizations
505: Where plan_id = v_plan_id);
506: COMMIT;
507: /*-------------+
508: | Get user id |

Line 540: msc_plan_organizations mpo

536: SYSDATE,
537: 1,
538: msi.netting_type
539: FROM msc_sub_inventories msi,
540: msc_plan_organizations mpo
541: WHERE NOT EXISTS
542: (SELECT NULL
543: FROM MSC_SUB_INVENTORIES SUB
544: WHERE SUB.ORGANIZATION_ID = mpo.organization_id

Line 582: msc_plan_organizations mpo

578: SYSDATE,
579: 1,
580: msi.netting_type
581: FROM msc_sub_inventories msi,
582: msc_plan_organizations mpo
583: WHERE NOT EXISTS
584: (SELECT NULL
585: FROM msc_sub_inventories sub
586: WHERE sub.organization_id = mpo.organization_id

Line 1455: Update MSC_PLAN_ORGANIZATIONS

1451: = ( select compile_designator,organization_id,sr_instance_id
1452: from msc_plans
1453: where plan_id=p_temp_plan_id);
1454:
1455: Update MSC_PLAN_ORGANIZATIONS
1456: set plan_completion_date = v_temp_plan_name_cur.Plan_Completion_Date,
1457: last_updated_by = v_temp_plan_name_cur.last_updated_by,
1458: last_update_date = v_temp_plan_name_cur.last_update_date,
1459: last_update_login = v_temp_plan_name_cur.last_update_login,

Line 1734: , msc_plan_organizations mpo

1730: , SYSDATE
1731: , 1
1732: , msi.netting_type
1733: FROM msc_sub_inventories msi
1734: , msc_plan_organizations mpo
1735: WHERE NOT EXISTS (SELECT NULL
1736: FROM MSC_SUB_INVENTORIES SUB
1737: WHERE SUB.ORGANIZATION_ID = mpo.organization_id
1738: AND sub.sr_instance_id = mpo.sr_instance_id