APPS.CSP_EXCESS_PARTS_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 224: from mtl_secondary_inventories msi,

220: and cpp.condition_type = 'G';
221:
222: cursor c_subinventories is
223: select msi.secondary_inventory_name
224: from mtl_secondary_inventories msi,
225: csp_planning_parameters cpp
226: where msi.organization_id = p_organization_id
227: and msi.secondary_inventory_name = nvl(p_subinventory_code,msi.secondary_inventory_name)
228: and cpp.organization_id = msi.organization_id

Line 1515: FROM MTL_SECONDARY_INVENTORIES S

1511: SUBINVENTORY = p_subinventory_code) -- Included later for ORG Level
1512: and (SUBINVENTORY is null or
1513: p_planning_level = 2 or
1514: EXISTS (SELECT 1
1515: FROM MTL_SECONDARY_INVENTORIES S
1516: WHERE S.ORGANIZATION_ID = p_organization_id
1517: AND S.SECONDARY_INVENTORY_NAME = SUBINVENTORY
1518: AND S.availability_type = DECODE(p_include_nonnet,
1519: 1,

Line 1540: FROM MTL_SECONDARY_INVENTORIES S

1536: SUBINVENTORY_CODE = p_subinventory_code) -- Included later for ORG Level
1537: and (SUBINVENTORY_CODE is null or
1538: p_planning_level = 2 or
1539: EXISTS (SELECT 1
1540: FROM MTL_SECONDARY_INVENTORIES S
1541: WHERE S.ORGANIZATION_ID = p_organization_id
1542: AND S.SECONDARY_INVENTORY_NAME = SUBINVENTORY_CODE
1543: AND S.availability_type = DECODE(p_include_nonnet,
1544: 1,

Line 1571: FROM MTL_SECONDARY_INVENTORIES S

1567: SUBINVENTORY = p_subinventory_code) -- Included later for ORG Level
1568: and (SUBINVENTORY is null or
1569: p_planning_level = 2 or
1570: EXISTS (SELECT 1
1571: FROM MTL_SECONDARY_INVENTORIES S
1572: WHERE S.ORGANIZATION_ID = p_organization_id
1573: AND S.SECONDARY_INVENTORY_NAME = SUBINVENTORY
1574: AND S.availability_type = DECODE(p_include_nonnet,
1575: 1,

Line 1596: FROM MTL_SECONDARY_INVENTORIES S

1592: SUBINVENTORY_CODE = p_subinventory_code) -- Included later for ORG Level
1593: and (SUBINVENTORY_CODE is null or
1594: p_planning_level = 2 or
1595: EXISTS (SELECT 1
1596: FROM MTL_SECONDARY_INVENTORIES S
1597: WHERE S.ORGANIZATION_ID = p_organization_id
1598: AND S.SECONDARY_INVENTORY_NAME = SUBINVENTORY_CODE
1599: AND S.availability_type = DECODE(p_include_nonnet,
1600: 1,

Line 1654: FROM MTL_SECONDARY_INVENTORIES S

1650: and schedule_ship_date <= sysdate + p_demand_cutoff
1651: and DECODE(so.SOURCE_DOCUMENT_TYPE_ID, 10, 8,DECODE(so.LINE_CATEGORY_CODE, 'ORDER',2,12)) = 8
1652: and (SUBINVENTORY is null or
1653: EXISTS (SELECT 1
1654: FROM MTL_SECONDARY_INVENTORIES S
1655: WHERE S.ORGANIZATION_ID = p_organization_id
1656: AND S.SECONDARY_INVENTORY_NAME = SUBINVENTORY
1657: AND S.availability_type = DECODE(p_include_nonnet,
1658: 1,

Line 1686: FROM MTL_SECONDARY_INVENTORIES S

1682: and REQUIREMENT_DATE <= sysdate + p_demand_cutoff
1683: and demand_source_type_id = 8
1684: and (SUBINVENTORY_CODE is null or
1685: EXISTS (SELECT 1
1686: FROM MTL_SECONDARY_INVENTORIES S
1687: WHERE S.ORGANIZATION_ID = p_organization_id
1688: AND S.SECONDARY_INVENTORY_NAME = SUBINVENTORY_CODE
1689: AND S.availability_type = DECODE(p_include_nonnet,
1690: 1,

Line 1784: FROM MTL_SECONDARY_INVENTORIES S

1780: from_subinventory_code = p_subinventory_code) -- Included later for ORG Level
1781: AND ( from_subinventory_code is null or
1782: p_planning_level = 2 or
1783: EXISTS (SELECT 1
1784: FROM MTL_SECONDARY_INVENTORIES S
1785: WHERE S.ORGANIZATION_ID = p_organization_id
1786: AND S.SECONDARY_INVENTORY_NAME = from_subinventory_code
1787: AND S.availability_type = DECODE(p_include_nonnet,
1788: 1,S.availability_type,1)))

Line 1806: FROM MTL_SECONDARY_INVENTORIES S

1802: MTRL.FROM_SUBINVENTORY_CODE = p_subinventory_code)
1803: AND (MTRL.FROM_SUBINVENTORY_CODE IS NULL OR
1804: p_planning_level = 2 OR
1805: EXISTS (SELECT 1
1806: FROM MTL_SECONDARY_INVENTORIES S
1807: WHERE S.ORGANIZATION_ID = p_organization_id
1808: AND S.SECONDARY_INVENTORY_NAME = MTRL.FROM_SUBINVENTORY_CODE
1809: AND S.AVAILABILITY_TYPE = DECODE(p_include_nonnet,
1810: 1,S.AVAILABILITY_TYPE,1)))