DBA Data[Home] [Help]

APPS.PO_LINK_REQ_DIST_PVT dependencies on ORG_ORGANIZATION_DEFINITIONS

Line 225: ORG_ORGANIZATION_DEFINITIONS OOD

221: SELECT PH.CURRENCY_CODE, PH.RATE, GLSOB.CURRENCY_CODE, GLSOB.SET_OF_BOOKS_ID, PH.ORG_ID
222: INTO L_CURRENCY_CODE, L_RATE , L_FUNC_CURRENCY_CODE, L_SOB, L_ORG_ID
223: FROM PO_HEADERS_DRAFT_ALL PH,
224: GL_SETS_OF_BOOKS GLSOB,
225: ORG_ORGANIZATION_DEFINITIONS OOD
226: WHERE PH.PO_HEADER_ID = L_HEADER_ID
227: AND PH.DRAFT_ID = L_DRAFT_ID
228: AND GLSOB.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID
229: AND OOD.ORGANIZATION_ID = PH.ORG_ID AND ROWNUM < 2;

Line 240: ORG_ORGANIZATION_DEFINITIONS OOD

236: SELECT PH.CURRENCY_CODE, PH.RATE, GLSOB.CURRENCY_CODE, GLSOB.SET_OF_BOOKS_ID, PH.ORG_ID
237: INTO L_CURRENCY_CODE, L_RATE , L_FUNC_CURRENCY_CODE, L_SOB, L_ORG_ID
238: FROM PO_HEADERS_ALL PH,
239: GL_SETS_OF_BOOKS GLSOB,
240: ORG_ORGANIZATION_DEFINITIONS OOD
241: WHERE PH.PO_HEADER_ID = L_HEADER_ID
242: AND GLSOB.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID
243: AND OOD.ORGANIZATION_ID = PH.ORG_ID AND ROWNUM < 2;
244:

Line 1109: ORG_ORGANIZATION_DEFINITIONS OOD

1105: SELECT PH.CURRENCY_CODE, PH.RATE, GLSOB.CURRENCY_CODE
1106: INTO L_CURRENCY_CODE, L_RATE , L_FUNC_CURRENCY_CODE
1107: FROM PO_HEADERS_DRAFT_ALL PH,
1108: GL_SETS_OF_BOOKS GLSOB,
1109: ORG_ORGANIZATION_DEFINITIONS OOD
1110: WHERE PH.PO_HEADER_ID = L_HEADER_ID
1111: AND PH.DRAFT_ID = L_DRAFT_ID
1112: AND GLSOB.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID
1113: AND OOD.ORGANIZATION_ID = PH.ORG_ID AND ROWNUM < 2;

Line 1180: ORG_ORGANIZATION_DEFINITIONS OOD

1176: SELECT PH.CURRENCY_CODE, PH.RATE, GLSOB.CURRENCY_CODE
1177: INTO L_CURRENCY_CODE, L_RATE , L_FUNC_CURRENCY_CODE
1178: FROM PO_HEADERS_ALL PH,
1179: GL_SETS_OF_BOOKS GLSOB,
1180: ORG_ORGANIZATION_DEFINITIONS OOD
1181: WHERE PH.PO_HEADER_ID = L_HEADER_ID
1182: AND GLSOB.SET_OF_BOOKS_ID = OOD.SET_OF_BOOKS_ID
1183: AND OOD.ORGANIZATION_ID = PH.ORG_ID AND ROWNUM < 2;
1184: