[Home] [Help]
1466: OR EXISTS (
1467: SELECT
1468: 1
1469: FROM
1470: MTL_SECONDARY_INVENTORIES S
1471: WHERE S.ORGANIZATION_ID = ORG_ID
1472: AND S.SECONDARY_INVENTORY_NAME = NVL(SUBINV
1473: ,SUBINVENTORY)
1474: AND S.AVAILABILITY_TYPE = DECODE(INCLUDE_NONNET
1532: OR EXISTS (
1533: SELECT
1534: 1
1535: FROM
1536: MTL_SECONDARY_INVENTORIES S
1537: WHERE S.ORGANIZATION_ID = LV_ORG_ID
1538: AND S.SECONDARY_INVENTORY_NAME = NVL(SUBINV
1539: ,SUBINVENTORY)
1540: AND S.AVAILABILITY_TYPE = DECODE(INCLUDE_NONNET
1586: OR EXISTS (
1587: SELECT
1588: 1
1589: FROM
1590: MTL_SECONDARY_INVENTORIES S
1591: WHERE S.ORGANIZATION_ID = ORG_ID
1592: AND S.SECONDARY_INVENTORY_NAME = MTR.SUBINVENTORY_CODE
1593: AND S.AVAILABILITY_TYPE = DECODE(INCLUDE_NONNET
1594: ,1
1681: OR EXISTS (
1682: SELECT
1683: 1
1684: FROM
1685: MTL_SECONDARY_INVENTORIES S
1686: WHERE S.ORGANIZATION_ID = ORG_ID
1687: AND S.SECONDARY_INVENTORY_NAME = MTRL.FROM_SUBINVENTORY_CODE
1688: AND S.AVAILABILITY_TYPE = DECODE(INCLUDE_NONNET
1689: ,1
1769: ''REQ'',sup.need_by_date,''ASN'',sup.need_by_date,''RECEIVING'',sup.receipt_date,''SHIPMENT'',sup.receipt_date),
1770: items.postprocessing_lead_time))) <=
1771: TO_DATE(''' || SCD || ''',''DD-MON-RRRR'')' || ' AND (NVL(sup.FROM_organization_id,-1) <>' || TO_CHAR(ORG_ID) || '
1772: OR (sup.FROM_organization_id =' || TO_CHAR(ORG_ID) || ' AND ' || TO_CHAR(INCLUDE_NONNET) || '= 2' || ' AND EXISTS (SELECT ''x''
1773: FROM mtl_secondary_inventories sub1
1774: WHERE sub1.organization_id = sup.FROM_organization_id
1775: AND sup.FROM_subinventory = sub1.secondary_inventory_name
1776: AND sub1.availability_type <> 1)))' || ' AND NOT EXISTS (select ''y''
1777: from oe_drop_ship_sources odss
1896: OR EXISTS (
1897: SELECT
1898: 1
1899: FROM
1900: MTL_SECONDARY_INVENTORIES SUB2
1901: WHERE SECONDARY_INVENTORY_NAME = DESTINATION_SUBINVENTORY
1902: AND DESTINATION_SUBINVENTORY = NVL(SUBINV
1903: ,DESTINATION_SUBINVENTORY)
1904: AND SUB2.ORGANIZATION_ID = ORG_ID1