APPS.CSL_MTL_SEC_LOCATORS_ACC_PKG dependencies on JTM_MTL_SYSTEM_ITEMS_ACC

Line 100: JTM_MTL_SYSTEM_ITEMS_ACC I, ASG_USER U

96: IS
97: CURSOR c_inserted( b_last_date DATE )
98: IS SELECT CSL_ACC_SEQUENCE.NEXTVAL, I.RESOURCE_ID, S.INVENTORY_ITEM_ID, S.SECONDARY_LOCATOR, S.ORGANIZATION_ID, I.COUNTER
99: FROM MTL_SECONDARY_LOCATORS S, CSL_MTL_ITEM_LOCATIONS_ACC A,
100: JTM_MTL_SYSTEM_ITEMS_ACC I, ASG_USER U
101: WHERE S.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
102: AND S.ORGANIZATION_ID = I.ORGANIZATION_ID
103: AND S.SECONDARY_LOCATOR = A.INVENTORY_LOCATION_ID
104: AND S.ORGANIZATION_ID = A.ORGANIZATION_ID

Line 148: JTM_MTL_SYSTEM_ITEMS_ACC I, ASG_USER U

144: , LAST_UPDATED_BY = 1
145: WHERE ( RESOURCE_ID, INVENTORY_ITEM_ID, SECONDARY_LOCATOR, ORGANIZATION_ID ) IN
146: ( SELECT I.RESOURCE_ID, S.INVENTORY_ITEM_ID, S.SECONDARY_LOCATOR, S.ORGANIZATION_ID
147: FROM MTL_SECONDARY_LOCATORS S, CSL_MTL_ITEM_LOCATIONS_ACC A,
148: JTM_MTL_SYSTEM_ITEMS_ACC I, ASG_USER U
149: WHERE S.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
150: AND S.ORGANIZATION_ID = I.ORGANIZATION_ID
151: AND S.SECONDARY_LOCATOR = A.INVENTORY_LOCATION_ID
152: AND S.ORGANIZATION_ID = A.ORGANIZATION_ID

Line 364: (upgrading with JTM_MTL_SYSTEM_ITEMS_ACC already filled).

360: END Delete_Secondary_Locators;
361:
362: /*
363: This procedure is used to populate the MTL_SECONDARY_LOCATORS records upon patching
364: (upgrading with JTM_MTL_SYSTEM_ITEMS_ACC already filled).
365: It's also called from CSL_MTL_SYSTEM_ITEMS_ACC_PKG.INSERT_ALL_ACC_RECORDS
366: */
367: PROCEDURE POPULATE_SEC_LOCATORS_ACC IS
368: PRAGMA AUTONOMOUS_TRANSACTION;

Line 372: JTM_MTL_SYSTEM_ITEMS_ACC I, ASG_USER U

368: PRAGMA AUTONOMOUS_TRANSACTION;
369: CURSOR c_inserted
370: IS SELECT CSL_ACC_SEQUENCE.NEXTVAL, I.RESOURCE_ID, S.INVENTORY_ITEM_ID, S.SECONDARY_LOCATOR, S.ORGANIZATION_ID, I.COUNTER
371: FROM MTL_SECONDARY_LOCATORS S, CSL_MTL_ITEM_LOCATIONS_ACC A,
372: JTM_MTL_SYSTEM_ITEMS_ACC I, ASG_USER U
373: WHERE S.INVENTORY_ITEM_ID = I.INVENTORY_ITEM_ID
374: AND S.ORGANIZATION_ID = I.ORGANIZATION_ID
375: AND S.SECONDARY_LOCATOR = A.INVENTORY_LOCATION_ID
376: AND S.ORGANIZATION_ID = A.ORGANIZATION_ID

Line 384: TYPE counter_Tab IS TABLE OF JTM_MTL_SYSTEM_ITEMS_ACC.COUNTER%TYPE INDEX BY BINARY_INTEGER;

380: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
381: TYPE inventory_item_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.INVENTORY_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
382: TYPE location_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.SECONDARY_LOCATOR%TYPE INDEX BY BINARY_INTEGER;
383: TYPE org_Tab IS TABLE OF MTL_SECONDARY_LOCATORS.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
384: TYPE counter_Tab IS TABLE OF JTM_MTL_SYSTEM_ITEMS_ACC.COUNTER%TYPE INDEX BY BINARY_INTEGER;
385: items inventory_item_Tab;
386: locations location_Tab;
387: organizations org_Tab;
388: counters counter_Tab;