DBA Data[Home] [Help]

APPS.PO_LINK_REQ_DIST_PVT dependencies on PO_HEADERS_ALL

Line 238: FROM PO_HEADERS_ALL PH,

234: DEBUG(D_MODULE, D_POSITION, 'FETCHING THE CURRENCY CODES, SOB, ORG ID ,RATE');
235:
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

Line 757: PO_HEADERS_ALL POH,

753: PO_REQ_DISTRIBUTIONS_ALL PRD,
754:
755: PO_LINE_LOCATIONS_ALL PLL,
756: PO_LINES_ALL POL ,
757: PO_HEADERS_ALL POH,
758:
759: (
760: SELECT
761: POLL.LINE_LOCATION_ID ,

Line 1178: FROM PO_HEADERS_ALL PH,

1174: DEBUG(D_MODULE, D_POSITION, 'FETCHING THE CURRENCY CODES, SOB, ORG ID ,RATE');
1175:
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