APPS.CSL_MTL_SERIAL_NUMBERS_ACC_PKG dependencies on CSP_INV_LOC_ASSIGNMENTS

Line 54: FROM CSP_INV_LOC_ASSIGNMENTS

50: WHERE CURRENT_STATUS IN (1,3)
51: AND ( CURRENT_SUBINVENTORY_CODE, CURRENT_ORGANIZATION_ID ) IN (
52: SELECT SUBINVENTORY_CODE
53: , ORGANIZATION_ID
54: FROM CSP_INV_LOC_ASSIGNMENTS
55: WHERE RESOURCE_ID = p_resource_id
56: AND RESOURCE_TYPE = 'RS_EMPLOYEE'
57: AND SYSDATE BETWEEN NVL( EFFECTIVE_DATE_START, SYSDATE )
58: AND NVL( EFFECTIVE_DATE_END , SYSDATE ))

Line 128: FROM CSP_INV_LOC_ASSIGNMENTS

124: AND msn.SERIAL_NUMBER = acc.SERIAL_NUMBER
125: AND ( msn.CURRENT_SUBINVENTORY_CODE, msn.CURRENT_ORGANIZATION_ID ) NOT IN (
126: SELECT SUBINVENTORY_CODE
127: , ORGANIZATION_ID
128: FROM CSP_INV_LOC_ASSIGNMENTS
129: WHERE RESOURCE_ID = acc.RESOURCE_ID
130: AND SYSDATE BETWEEN NVL( EFFECTIVE_DATE_START, SYSDATE )
131: AND NVL( EFFECTIVE_DATE_END , SYSDATE ))
132: UNION

Line 148: FROM CSP_INV_LOC_ASSIGNMENTS cila

144: WHERE msn.SERIAL_NUMBER = acc.SERIAL_NUMBER
145: AND msn.INVENTORY_ITEM_ID = acc.INVENTORY_ITEM_ID
146: AND (NOT EXISTS
147: (SELECT 1
148: FROM CSP_INV_LOC_ASSIGNMENTS cila
149: WHERE cila.RESOURCE_ID = acc.RESOURCE_ID
150: AND cila.organization_id = msn.current_organization_id
151: AND cila.subinventory_code = msn.current_subinventory_code
152: AND SYSDATE BETWEEN NVL( cila.EFFECTIVE_DATE_START, SYSDATE )

Line 233: FROM CSP_INV_LOC_ASSIGNMENTS

229: AND msn.LAST_UPDATE_DATE >= p_date
230: AND ( msn.CURRENT_SUBINVENTORY_CODE, msn.CURRENT_ORGANIZATION_ID ) IN (
231: SELECT SUBINVENTORY_CODE
232: , ORGANIZATION_ID
233: FROM CSP_INV_LOC_ASSIGNMENTS
234: WHERE RESOURCE_ID = acc.RESOURCE_ID
235: AND SYSDATE BETWEEN NVL( EFFECTIVE_DATE_START, SYSDATE )
236: AND NVL( EFFECTIVE_DATE_END , SYSDATE ));
237: