[Home] [Help]
219:
220:
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
520: PO_REQ_DISTRIBUTIONS_ALL PRD,
521:
522: PO_LINE_LOCATIONS_MERGE_V PLL,
523: PO_LINES_MERGE_V POL ,
524: PO_HEADERS_DRAFT_ALL POH,
525:
526: (
527: SELECT
528: POLL.LINE_LOCATION_ID ,
1103:
1104:
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