APPS.CSP_EXCESS_PARTS_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 226: from mtl_secondary_inventories msi,

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

Line 1636: FROM MTL_SECONDARY_INVENTORIES S

1632: SUBINVENTORY = p_subinventory_code) -- Included later for ORG Level
1633: and (SUBINVENTORY is null or
1634: p_planning_level = 2 or
1635: EXISTS (SELECT 1
1636: FROM MTL_SECONDARY_INVENTORIES S
1637: WHERE S.ORGANIZATION_ID = p_organization_id
1638: AND S.SECONDARY_INVENTORY_NAME = SUBINVENTORY
1639: AND S.availability_type = DECODE(p_include_nonnet,
1640: 1,

Line 1661: FROM MTL_SECONDARY_INVENTORIES S

1657: SUBINVENTORY_CODE = p_subinventory_code) -- Included later for ORG Level
1658: and (SUBINVENTORY_CODE is null or
1659: p_planning_level = 2 or
1660: EXISTS (SELECT 1
1661: FROM MTL_SECONDARY_INVENTORIES S
1662: WHERE S.ORGANIZATION_ID = p_organization_id
1663: AND S.SECONDARY_INVENTORY_NAME = SUBINVENTORY_CODE
1664: AND S.availability_type = DECODE(p_include_nonnet,
1665: 1,

Line 1692: FROM MTL_SECONDARY_INVENTORIES S

1688: SUBINVENTORY = p_subinventory_code) -- Included later for ORG Level
1689: and (SUBINVENTORY is null or
1690: p_planning_level = 2 or
1691: EXISTS (SELECT 1
1692: FROM MTL_SECONDARY_INVENTORIES S
1693: WHERE S.ORGANIZATION_ID = p_organization_id
1694: AND S.SECONDARY_INVENTORY_NAME = SUBINVENTORY
1695: AND S.availability_type = DECODE(p_include_nonnet,
1696: 1,

Line 1717: FROM MTL_SECONDARY_INVENTORIES S

1713: SUBINVENTORY_CODE = p_subinventory_code) -- Included later for ORG Level
1714: and (SUBINVENTORY_CODE is null or
1715: p_planning_level = 2 or
1716: EXISTS (SELECT 1
1717: FROM MTL_SECONDARY_INVENTORIES S
1718: WHERE S.ORGANIZATION_ID = p_organization_id
1719: AND S.SECONDARY_INVENTORY_NAME = SUBINVENTORY_CODE
1720: AND S.availability_type = DECODE(p_include_nonnet,
1721: 1,

Line 1775: FROM MTL_SECONDARY_INVENTORIES S

1771: and schedule_ship_date <= sysdate + p_demand_cutoff
1772: and DECODE(so.SOURCE_DOCUMENT_TYPE_ID, 10, 8,DECODE(so.LINE_CATEGORY_CODE, 'ORDER',2,12)) = 8
1773: and (SUBINVENTORY is null or
1774: EXISTS (SELECT 1
1775: FROM MTL_SECONDARY_INVENTORIES S
1776: WHERE S.ORGANIZATION_ID = p_organization_id
1777: AND S.SECONDARY_INVENTORY_NAME = SUBINVENTORY
1778: AND S.availability_type = DECODE(p_include_nonnet,
1779: 1,

Line 1807: FROM MTL_SECONDARY_INVENTORIES S

1803: and REQUIREMENT_DATE <= sysdate + p_demand_cutoff
1804: and demand_source_type_id = 8
1805: and (SUBINVENTORY_CODE is null or
1806: EXISTS (SELECT 1
1807: FROM MTL_SECONDARY_INVENTORIES S
1808: WHERE S.ORGANIZATION_ID = p_organization_id
1809: AND S.SECONDARY_INVENTORY_NAME = SUBINVENTORY_CODE
1810: AND S.availability_type = DECODE(p_include_nonnet,
1811: 1,

Line 1905: FROM MTL_SECONDARY_INVENTORIES S

1901: from_subinventory_code = p_subinventory_code) -- Included later for ORG Level
1902: AND ( from_subinventory_code is null or
1903: p_planning_level = 2 or
1904: EXISTS (SELECT 1
1905: FROM MTL_SECONDARY_INVENTORIES S
1906: WHERE S.ORGANIZATION_ID = p_organization_id
1907: AND S.SECONDARY_INVENTORY_NAME = from_subinventory_code
1908: AND S.availability_type = DECODE(p_include_nonnet,
1909: 1,S.availability_type,1)))

Line 1927: FROM MTL_SECONDARY_INVENTORIES S

1923: MTRL.FROM_SUBINVENTORY_CODE = p_subinventory_code)
1924: AND (MTRL.FROM_SUBINVENTORY_CODE IS NULL OR
1925: p_planning_level = 2 OR
1926: EXISTS (SELECT 1
1927: FROM MTL_SECONDARY_INVENTORIES S
1928: WHERE S.ORGANIZATION_ID = p_organization_id
1929: AND S.SECONDARY_INVENTORY_NAME = MTRL.FROM_SUBINVENTORY_CODE
1930: AND S.AVAILABILITY_TYPE = DECODE(p_include_nonnet,
1931: 1,S.AVAILABILITY_TYPE,1)))

Line 2449: MTL_SECONDARY_INVENTORIES sub,

2445: null as province,
2446: null as county,
2447: hrloc.country as country
2448: from
2449: MTL_SECONDARY_INVENTORIES sub,
2450: hr_all_organization_units org,
2451: hr_locations_all hrloc
2452: where org.organization_id = v_org_id
2453: and org.organization_id = sub.organization_id(+)

Line 2763: mtl_secondary_inventories msi,

2759: cpp.hz_location_id,
2760: msi.location_id,
2761: ood.operating_unit
2762: from csp_return_routing_rules crrr,
2763: mtl_secondary_inventories msi,
2764: csp_planning_parameters cpp,
2765: org_organization_definitions ood
2766: where crrr.rule_id = p_return_rule_id
2767: and crrr.dest_org_id = msi.organization_id