eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSL_MTL_ITEM_LOCATIONS_ACC_PKG dependencies on JTM_MTL_SEC_INV_ACC

Line 107: FROM JTM_MTL_SEC_INV_ACC SEC, MTL_ITEM_LOCATIONS LOC

103: PROCEDURE INSERT_ACC_REC_MARKDIRTY( p_last_run_date IN DATE )
104: IS
105: CURSOR c_inserted( b_last_date DATE ) IS
106: SELECT CSL_ACC_SEQUENCE.NEXTVAL, SEC.RESOURCE_ID, LOC.INVENTORY_LOCATION_ID, LOC.ORGANIZATION_ID, SEC.COUNTER
107: FROM JTM_MTL_SEC_INV_ACC SEC, MTL_ITEM_LOCATIONS LOC
108: WHERE SEC.SECONDARY_INVENTORY_NAME = LOC.SUBINVENTORY_CODE
109: AND SEC.ORGANIZATION_ID = LOC.ORGANIZATION_ID
110: AND LOC.CREATION_DATE >= NVL(b_last_date, LOC.CREATION_DATE)
111: AND (SEC.RESOURCE_ID, LOC.INVENTORY_LOCATION_ID, LOC.ORGANIZATION_ID)

Line 121: TYPE counter_Tab IS TABLE OF JTM_MTL_SEC_INV_ACC.COUNTER%TYPE INDEX BY BINARY_INTEGER;

117: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
118: l_tab_resource_id ASG_DOWNLOAD.USER_LIST;
119: TYPE location_Tab IS TABLE OF MTL_ITEM_LOCATIONS.INVENTORY_LOCATION_ID%TYPE INDEX BY BINARY_INTEGER;
120: TYPE org_Tab IS TABLE OF MTL_ITEM_LOCATIONS.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
121: TYPE counter_Tab IS TABLE OF JTM_MTL_SEC_INV_ACC.COUNTER%TYPE INDEX BY BINARY_INTEGER;
122: locations location_Tab;
123: organizations org_Tab;
124: counters counter_Tab;
125:

Line 145: FROM JTM_MTL_SEC_INV_ACC SEC, MTL_ITEM_LOCATIONS LOC

141: , LAST_UPDATE_DATE = SYSDATE
142: , LAST_UPDATED_BY = 1
143: WHERE ( RESOURCE_ID, INVENTORY_LOCATION_ID, ORGANIZATION_ID ) IN
144: ( SELECT SEC.RESOURCE_ID, LOC.INVENTORY_LOCATION_ID, LOC.ORGANIZATION_ID
145: FROM JTM_MTL_SEC_INV_ACC SEC, MTL_ITEM_LOCATIONS LOC
146: WHERE SEC.SECONDARY_INVENTORY_NAME = LOC.SUBINVENTORY_CODE
147: AND LOC.CREATION_DATE >= NVL(p_last_run_date, LOC.CREATION_DATE)
148: );
149:

Line 437: FROM MTL_ITEM_LOCATIONS L, JTM_MTL_SEC_INV_ACC A

433: IS
434: PRAGMA AUTONOMOUS_TRANSACTION;
435: CURSOR c_inserted
436: IS SELECT CSL_ACC_SEQUENCE.NEXTVAL, A.RESOURCE_ID, L.INVENTORY_LOCATION_ID, L.ORGANIZATION_ID, A.COUNTER
437: FROM MTL_ITEM_LOCATIONS L, JTM_MTL_SEC_INV_ACC A
438: WHERE L.SUBINVENTORY_CODE = A.SECONDARY_INVENTORY_NAME
439: AND L.ORGANIZATION_ID = A.ORGANIZATION_ID;
440:
441: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;