DBA Data[Home] [Help]

APPS.OE_RMA_QUERY_RECEIVE dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 25: FROM ORG_ORGANIZATION_DEFINITIONS ORGDEF1,

21: AND INVENTORY_ITEM_ID = P_INVENTORY_ITEM_ID
22: AND NVL(RETURNABLE_FLAG, 'Y') = 'Y'
23: AND EXISTS
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);

Line 26: ORG_ORGANIZATION_DEFINITIONS ORGDEF2

22: AND NVL(RETURNABLE_FLAG, 'Y') = 'Y'
23: AND EXISTS
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: