[Home] [Help]
1495: where sd.publisher_order_type = 3 and
1496: sd.plan_id = -1 and
1497: sd.publisher_id = 1 and
1498: sd.publisher_site_id IN (select cs.company_site_id
1499: from msc_plan_organizations o,
1500: msc_company_sites cs,
1501: msc_trading_partner_maps m,
1502: msc_trading_partners p
1503: where o.plan_id = p_plan_id and
1511: sd.customer_id = nvl(l_customer_id, sd.customer_id) and
1512: sd.customer_site_id = nvl(l_customer_site_id, sd.customer_site_id) and
1513: NVL(sd.base_item_id, sd.inventory_item_id) IN (select nvl(i.base_item_id,i.inventory_item_id)
1514: from msc_system_items i,
1515: msc_plan_organizations o
1516: where o.plan_id = p_plan_id and
1517: i.plan_id = o.plan_id and
1518: i.organization_id = nvl(p_org_id,
1519: o.organization_id) and
1538: where sd.publisher_order_type = 3 and
1539: sd.plan_id = -1 and
1540: sd.publisher_id = 1 and
1541: sd.publisher_site_id IN (select cs.company_site_id
1542: from msc_plan_organizations o,
1543: msc_company_sites cs,
1544: msc_trading_partner_maps m,
1545: msc_trading_partners p
1546: where o.plan_id = p_plan_id and
1554: sd.customer_id = nvl(l_customer_id, sd.customer_id) and
1555: sd.customer_site_id = nvl(l_customer_site_id, sd.customer_site_id) and
1556: NVL(sd.base_item_id, sd.inventory_item_id) IN (select nvl(i.base_item_id,i.inventory_item_id)
1557: from msc_system_items i,
1558: msc_plan_organizations o
1559: where o.plan_id = p_plan_id and
1560: i.plan_id = o.plan_id and
1561: i.organization_id = nvl(p_org_id,
1562: o.organization_id) and