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.OE_RMA_QUERY_RECEIVE dependencies on SO_ITEM_WAREHOUSES_V

Line 19: FROM SO_ITEM_WAREHOUSES_V

15: BEGIN
16:
17: SELECT ORGANIZATION_ID
18: INTO P_WAREHOUSE_ID
19: FROM SO_ITEM_WAREHOUSES_V
20: WHERE ORGANIZATION_ID = P_WAREHOUSE_ID
21: AND INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
22: AND NVL(RETURNABLE_FLAG, 'Y') = 'Y'
23: AND EXISTS

Line 28: AND ORGDEF2.ORGANIZATION_ID = SO_ITEM_WAREHOUSES_V.ORGANIZATION_ID

24: (SELECT 'SAME CHART OF ACCOUNTS'
25: FROM ORG_ORGANIZATION_DEFINITIONS ORGDEF1,
26: ORG_ORGANIZATION_DEFINITIONS ORGDEF2
27: WHERE ORGDEF1.SET_OF_BOOKS_ID = X_SET_OF_BOOKS_ID
28: AND ORGDEF2.ORGANIZATION_ID = SO_ITEM_WAREHOUSES_V.ORGANIZATION_ID
29: AND ORGDEF1.CHART_OF_ACCOUNTS_ID = ORGDEF2.CHART_OF_ACCOUNTS_ID);
30:
31: RETURN;
32: