APPS.MSC_X_WFNOTIFY_PKG dependencies on MSC_PLAN_ORGANIZATIONS

Line 1379: from msc_plan_organizations o,

1375: WHERE sd.publisher_order_type = p_publish_program_type and
1376: sd.plan_id = -1 and
1377: sd.publisher_id = 1 and
1378: exists (select cs.company_site_id
1379: from msc_plan_organizations o,
1380: msc_company_sites cs,
1381: msc_trading_partner_maps m,
1382: msc_trading_partners p
1383: where o.plan_id = p_plan_id

Line 1415: msc_plan_organizations o

1411: s.company_id = sd.supplier_id and
1412: sd.supplier_site_id=s.company_site_id and rownum=1) and
1413: exists (select nvl(i.base_item_id,i.inventory_item_id)
1414: from msc_system_items i,
1415: msc_plan_organizations o
1416: where o.plan_id = p_plan_id and
1417: i.plan_id = o.plan_id
1418: AND O.ORGANIZATION_ID = NVL(p_org_id , O.ORGANIZATION_ID)
1419: AND O.SR_INSTANCE_ID =NVL(p_sr_instance_id , O.SR_INSTANCE_ID)

Line 1509: from msc_plan_organizations o,

1505: WHERE sd.publisher_order_type = p_publish_program_type and
1506: sd.plan_id = -1 and
1507: sd.publisher_id = 1 and
1508: sd.publisher_site_id IN (select cs.company_site_id
1509: from msc_plan_organizations o,
1510: msc_company_sites cs,
1511: msc_trading_partner_maps m,
1512: msc_trading_partners p
1513: where o.plan_id = p_plan_id and

Line 1541: msc_plan_organizations o

1537: s.company_site_id = m.company_key and
1538: s.company_id = sd.customer_id) and
1539: NVL(sd.base_item_id, sd.inventory_item_id) IN (select nvl(i.base_item_id,i.inventory_item_id)
1540: from msc_system_items i,
1541: msc_plan_organizations o
1542: where o.plan_id = p_plan_id and
1543: i.plan_id = o.plan_id and
1544: i.organization_id = nvl(p_org_id,
1545: o.organization_id) and