APPS.MRP_LAUNCH_PLAN_PK dependencies on MRP_SUB_INVENTORIES

Line 84: | Insert subinventories into mrp_sub_inventories |

80: +--------------*/
81:
82: var_user_id := fnd_profile.value('USER_ID');
83: /*-----------------------------------------------+
84: | Insert subinventories into mrp_sub_inventories |
85: | that are defined after options are defined |
86: +-----------------------------------------------*/
87: BEGIN
88: INSERT INTO MRP_SUB_INVENTORIES

Line 88: INSERT INTO MRP_SUB_INVENTORIES

84: | Insert subinventories into mrp_sub_inventories |
85: | that are defined after options are defined |
86: +-----------------------------------------------*/
87: BEGIN
88: INSERT INTO MRP_SUB_INVENTORIES
89: (SUB_INVENTORY_CODE,
90: ORGANIZATION_ID,
91: COMPILE_DESIGNATOR,
92: CREATION_DATE,

Line 111: FROM MRP_SUB_INVENTORIES SUB

107: FROM MTL_SECONDARY_INVENTORIES msi,
108: mrp_plan_organizations_v mpo
109: WHERE NOT EXISTS
110: (SELECT NULL
111: FROM MRP_SUB_INVENTORIES SUB
112: WHERE SUB.ORGANIZATION_ID = mpo.planned_organization
113: AND SUB.COMPILE_DESIGNATOR = mpo.compile_designator
114: AND SUB.sub_inventory_code = msi.SECONDARY_INVENTORY_NAME)
115: AND NVL(MSI.DISABLE_DATE, SYSDATE + 1) > TRUNC(SYSDATE)