DBA Data[Home] [Help]

APPS.CSP_PLANNING_PARAMETERS_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 140: from mtl_secondary_inventories

136: l_meaning Varchar2(2000);
137:
138: CURSOR C_SEC_INV(L_ORGANIZATION_ID NUMBER) IS
139: Select secondary_inventory_name
140: from mtl_secondary_inventories
141: where organization_id = L_ORGANIZATION_ID
142: and nvl(Disable_date,Sysdate+1) > Sysdate
143: and secondary_inventory_name not in
144: (Select secondary_inventory from csp_planning_parameters

Line 150: from mtl_secondary_inventories

146: and rownum =1;
147:
148: CURSOR C_SEC_INV2(L_ORGANIZATION_ID NUMBER,P_SECONDARY_INVENTORY Varchar2) IS
149: Select secondary_inventory_name
150: from mtl_secondary_inventories
151: where organization_id = L_ORGANIZATION_ID
152: AND SECONDARY_INVENTORY_NAME <> P_SECONDARY_INVENTORY
153: and nvl(Disable_date,Sysdate+1) > Sysdate
154: and secondary_inventory_name not in