APPS.MSC_M2A_PUSH dependencies on MSC_PLAN_ORGANIZATIONS

Line 334: from msc_plan_organizations

330: where sr_instance_id = pINSTANCE_ID
331: and compile_designator = pDESIGNATOR;
332: CURSOR c2 (c_plan_id number) IS
333: select organization_id
334: from msc_plan_organizations
335: where sr_instance_id = pINSTANCE_ID
336: and organization_id = nvl(pORGANIZATION_ID,organization_id)
337: and plan_id = c_plan_id;
338:

Line 430: ||'FROM MSC_PLAN_ORGANIZATIONS '

426: ||' ATTRIBUTE12 ,'
427: ||' ATTRIBUTE13 ,'
428: ||' ATTRIBUTE14 ,'
429: ||' ATTRIBUTE15 '
430: ||'FROM MSC_PLAN_ORGANIZATIONS '
431: ||'WHERE plan_id = :plan_id '
432: ||'AND sr_instance_id = :pINSTANCE_ID '
433: ||' AND organization_id = :organization_id1 ';
434:

Line 839: from msc_plan_organizations

835: where sr_instance_id = pINSTANCE_ID
836: and compile_designator = pDESIGNATOR;
837: CURSOR c2 (c_plan_id number) IS
838: select organization_id
839: from msc_plan_organizations
840: where sr_instance_id = pINSTANCE_ID
841: and organization_id = nvl(pORGANIZATION_ID,organization_id)
842: and plan_id = c_plan_id;
843: CURSOR c3 (c_plan_id number) IS

Line 1007: ||' FROM MSC_PLAN_ORGANIZATIONS_V MPOV'

1003: lv_sql_stmt :=
1004: 'DELETE FROM MRP_RECOMMENDATIONS'||v_dblink||' MRO'
1005: ||' WHERE MRO.COMPILE_DESIGNATOR = :pDESIGNATOR '
1006: ||' AND MRO.ORGANIZATION_ID IN (SELECT MPOV.PLANNED_ORGANIZATION'
1007: ||' FROM MSC_PLAN_ORGANIZATIONS_V MPOV'
1008: ||' WHERE MPOV.SR_INSTANCE_ID = :pINSTANCE_ID'
1009: ||' AND MPOV.COMPILE_DESIGNATOR = :pDESIGNATOR)';
1010:
1011: IF pORGANIZATION_ID IS NOT NULL THEN

Line 1112: ||' FROM MSC_PLAN_ORGANIZATIONS_V MPOV'

1108:
1109: lv_sql_stmt := 'DELETE FROM MRP_SYSTEM_ITEMS'||v_dblink||' MSI'
1110: ||' WHERE MSI.COMPILE_DESIGNATOR = :pDESIGNATOR '
1111: ||' AND MSI.ORGANIZATION_ID IN (SELECT MPOV.PLANNED_ORGANIZATION'
1112: ||' FROM MSC_PLAN_ORGANIZATIONS_V MPOV'
1113: ||' WHERE MPOV.SR_INSTANCE_ID = :pINSTANCE_ID'
1114: ||' AND MPOV.COMPILE_DESIGNATOR = :pDESIGNATOR)';
1115:
1116:

Line 1191: ||' FROM MSC_PLAN_ORGANIZATIONS_V MPOV'

1187:
1188: lv_sql_stmt := 'DELETE FROM MRP_GROSS_REQUIREMENTS'||v_dblink||' MGR'
1189: ||' WHERE MGR.COMPILE_DESIGNATOR = :pDESIGNATOR '
1190: ||' AND MGR.ORGANIZATION_ID IN (SELECT MPOV.PLANNED_ORGANIZATION'
1191: ||' FROM MSC_PLAN_ORGANIZATIONS_V MPOV'
1192: ||' WHERE MPOV.SR_INSTANCE_ID = :pINSTANCE_ID'
1193: ||' AND MPOV.COMPILE_DESIGNATOR = :pDESIGNATOR)';
1194:
1195:

Line 2267: ||' FROM MSC_PLAN_ORGANIZATIONS_V MPOV'

2263: ||' WHERE msi.plan_id = :PLAN_ID'
2264: ||' AND msi.sr_instance_id = :pINSTANCE_ID'
2265: -- check orgs which are in the plan only bug#7016427 **hbinjola**
2266: ||' AND msi.ORGANIZATION_ID IN (SELECT MPOV.PLANNED_ORGANIZATION'
2267: ||' FROM MSC_PLAN_ORGANIZATIONS_V MPOV'
2268: ||' WHERE MPOV.SR_INSTANCE_ID = :pINSTANCE_ID'
2269: ||' AND MPOV.COMPILE_DESIGNATOR = :pDESIGNATOR)';
2270:
2271:

Line 2500: ||' FROM MSC_PLAN_ORGANIZATIONS_V MPOV'

2496: lv_sql_stmt :=
2497: 'DELETE FROM MRP_SCHEDULE_DATES'||v_dblink||' MSD'
2498: ||' WHERE MSD.SCHEDULE_DESIGNATOR = :pDESIGNATOR '
2499: ||' AND MSD.ORGANIZATION_ID IN (SELECT MPOV.PLANNED_ORGANIZATION'
2500: ||' FROM MSC_PLAN_ORGANIZATIONS_V MPOV'
2501: ||' WHERE MPOV.SR_INSTANCE_ID = :pINSTANCE_ID'
2502: ||' AND MPOV.COMPILE_DESIGNATOR = :pDESIGNATOR)';
2503:
2504: Execute immediate lv_sql_stmt using pDESIGNATOR, pINSTANCE_ID, pDESIGNATOR;

Line 2513: ||' FROM MSC_PLAN_ORGANIZATIONS_V MPOV'

2509: lv_sql_stmt :=
2510: 'DELETE FROM MRP_SCHEDULE_ITEMS'||v_dblink||' MSI'
2511: ||' WHERE MSI.SCHEDULE_DESIGNATOR = :pDESIGNATOR '
2512: ||' AND MSI.ORGANIZATION_ID IN (SELECT MPOV.PLANNED_ORGANIZATION'
2513: ||' FROM MSC_PLAN_ORGANIZATIONS_V MPOV'
2514: ||' WHERE MPOV.SR_INSTANCE_ID = :pINSTANCE_ID'
2515: ||' AND MPOV.COMPILE_DESIGNATOR = :pDESIGNATOR)';
2516:
2517: Execute immediate lv_sql_stmt using pDESIGNATOR, pINSTANCE_ID, pDESIGNATOR;