DBA Data[Home] [Help]

APPS.CSP_SCH_INT_PVT dependencies on CSP_SEC_INVENTORIES

Line 4672: FROM CSP_INV_LOC_ASSIGNMENTS cil,csp_sec_inventories csi

4668: l_items csp_sch_int_pvt.alternate_items_table_type;
4669:
4670: CURSOR get_all_subinventories(l_resource_id number, l_resource_type varchar2) IS
4671: SELECT cil.ORGANIZATION_ID, cil.SUBINVENTORY_CODE
4672: FROM CSP_INV_LOC_ASSIGNMENTS cil,csp_sec_inventories csi
4673: WHERE cil.RESOURCE_ID = l_resource_id
4674: AND cil.RESOURCE_TYPE = l_resource_type
4675: AND nvl(cil.EFFECTIVE_DATE_END,sysdate) >= sysdate
4676: AND csi.organization_id = cil.organization_id