APPS.CSL_MTL_SERIAL_NUMBERS_ACC_PKG dependencies on JTM_MTL_SERIAL_NUMBERS_ACC

Line 61: FROM JTM_MTL_SERIAL_NUMBERS_ACC

57: AND SYSDATE BETWEEN NVL( EFFECTIVE_DATE_START, SYSDATE )
58: AND NVL( EFFECTIVE_DATE_END , SYSDATE ))
59: AND ( INVENTORY_ITEM_ID, SERIAL_NUMBER ) NOT IN (
60: SELECT INVENTORY_ITEM_ID, SERIAL_NUMBER
61: FROM JTM_MTL_SERIAL_NUMBERS_ACC
62: WHERE RESOURCE_ID = p_resource_id );
63:
64: IF sequences.COUNT > 0 THEN
65: FORALL i IN sequences.FIRST..sequences.LAST

Line 66: INSERT INTO JTM_MTL_SERIAL_NUMBERS_ACC(

62: WHERE RESOURCE_ID = p_resource_id );
63:
64: IF sequences.COUNT > 0 THEN
65: FORALL i IN sequences.FIRST..sequences.LAST
66: INSERT INTO JTM_MTL_SERIAL_NUMBERS_ACC(
67: ACCESS_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY
68: , COUNTER, RESOURCE_ID, INVENTORY_ITEM_ID, SERIAL_NUMBER ) VALUES (
69: sequences(i), sysdate, 1, sysdate, 1, 1, p_resource_id, items(i), serials(i));
70:

Line 121: FROM JTM_MTL_SERIAL_NUMBERS_ACC acc

117: CURSOR c_remove IS
118: /* Performance bug (3920090)fixing */
119: /*
120: SELECT acc.ACCESS_ID, acc.RESOURCE_ID
121: FROM JTM_MTL_SERIAL_NUMBERS_ACC acc
122: , MTL_SERIAL_NUMBERS msn
123: WHERE msn.INVENTORY_ITEM_ID = acc.INVENTORY_ITEM_ID
124: AND msn.SERIAL_NUMBER = acc.SERIAL_NUMBER
125: AND ( msn.CURRENT_SUBINVENTORY_CODE, msn.CURRENT_ORGANIZATION_ID ) NOT IN (

Line 134: FROM JTM_MTL_SERIAL_NUMBERS_ACC acc

130: AND SYSDATE BETWEEN NVL( EFFECTIVE_DATE_START, SYSDATE )
131: AND NVL( EFFECTIVE_DATE_END , SYSDATE ))
132: UNION
133: SELECT acc.ACCESS_ID, acc.RESOURCE_ID
134: FROM JTM_MTL_SERIAL_NUMBERS_ACC acc
135: , MTL_SERIAL_NUMBERS msn
136: WHERE msn.INVENTORY_ITEM_ID = acc.INVENTORY_ITEM_ID
137: AND msn.SERIAL_NUMBER = acc.SERIAL_NUMBER
138: AND msn.CURRENT_STATUS NOT IN (1,3);

Line 142: FROM JTM_MTL_SERIAL_NUMBERS_ACC acc

138: AND msn.CURRENT_STATUS NOT IN (1,3);
139: */
140: SELECT /*+ INDEX (msn MTL_SERIAL_NUMBERS_U1) */
141: acc.ACCESS_ID, acc.RESOURCE_ID
142: FROM JTM_MTL_SERIAL_NUMBERS_ACC acc
143: , MTL_SERIAL_NUMBERS msn
144: WHERE msn.SERIAL_NUMBER = acc.SERIAL_NUMBER
145: AND msn.INVENTORY_ITEM_ID = acc.INVENTORY_ITEM_ID
146: AND (NOT EXISTS

Line 195: DELETE JTM_MTL_SERIAL_NUMBERS_ACC

191: );
192:
193: /*To avoid a mismatch only delete records which are marked dirty*/
194: FORALL i IN l_tab_access_id.FIRST..l_tab_access_id.LAST
195: DELETE JTM_MTL_SERIAL_NUMBERS_ACC
196: WHERE ACCESS_ID = l_tab_access_id(i);
197: END IF;
198: CLOSE c_remove;
199:

Line 225: FROM JTM_MTL_SERIAL_NUMBERS_ACC acc

221: IS
222: /*Get all existing and valid records which are changed*/
223: CURSOR c_changed( b_date DATE ) IS
224: SELECT acc.ACCESS_ID, acc.RESOURCE_ID
225: FROM JTM_MTL_SERIAL_NUMBERS_ACC acc
226: , MTL_SERIAL_NUMBERS msn
227: WHERE msn.INVENTORY_ITEM_ID = acc.INVENTORY_ITEM_ID
228: AND msn.SERIAL_NUMBER = acc.SERIAL_NUMBER
229: AND msn.LAST_UPDATE_DATE >= p_date