DBA Data[Home] [Help]

APPS.CSP_SCH_INT_PVT dependencies on CSP_SEC_INVENTORIES

Line 7214: FROM CSP_INV_LOC_ASSIGNMENTS cil,csp_sec_inventories csi

7210: l_items csp_sch_int_pvt.alternate_items_table_type;
7211:
7212: CURSOR get_all_subinventories(l_resource_id number, l_resource_type varchar2) IS
7213: SELECT cil.ORGANIZATION_ID, cil.SUBINVENTORY_CODE
7214: FROM CSP_INV_LOC_ASSIGNMENTS cil,csp_sec_inventories csi
7215: WHERE cil.RESOURCE_ID = l_resource_id
7216: AND cil.RESOURCE_TYPE = l_resource_type
7217: AND nvl(cil.EFFECTIVE_DATE_END,sysdate) >= sysdate
7218: AND csi.organization_id = cil.organization_id