[Home] [Help]
1459: where sd.publisher_order_type = 3 and
1460: sd.plan_id = -1 and
1461: sd.publisher_id = 1 and
1462: sd.publisher_site_id IN (select cs.company_site_id
1463: from msc_plan_organizations o,
1464: msc_company_sites cs,
1465: msc_trading_partner_maps m,
1466: msc_trading_partners p
1467: where o.plan_id = p_plan_id and
1475: sd.customer_id = nvl(l_customer_id, sd.customer_id) and
1476: sd.customer_site_id = nvl(l_customer_site_id, sd.customer_site_id) and
1477: NVL(sd.base_item_id, sd.inventory_item_id) IN (select nvl(i.base_item_id,i.inventory_item_id)
1478: from msc_system_items i,
1479: msc_plan_organizations o
1480: where o.plan_id = p_plan_id and
1481: i.plan_id = o.plan_id and
1482: i.organization_id = nvl(p_org_id,
1483: o.organization_id) and
1502: where sd.publisher_order_type = 3 and
1503: sd.plan_id = -1 and
1504: sd.publisher_id = 1 and
1505: sd.publisher_site_id IN (select cs.company_site_id
1506: from msc_plan_organizations o,
1507: msc_company_sites cs,
1508: msc_trading_partner_maps m,
1509: msc_trading_partners p
1510: where o.plan_id = p_plan_id and
1518: sd.customer_id = nvl(l_customer_id, sd.customer_id) and
1519: sd.customer_site_id = nvl(l_customer_site_id, sd.customer_site_id) and
1520: NVL(sd.base_item_id, sd.inventory_item_id) IN (select nvl(i.base_item_id,i.inventory_item_id)
1521: from msc_system_items i,
1522: msc_plan_organizations o
1523: where o.plan_id = p_plan_id and
1524: i.plan_id = o.plan_id and
1525: i.organization_id = nvl(p_org_id,
1526: o.organization_id) and