VIEW: APPS.PO_ENC_AEL_GL_V

Source

View Text - Preformatted

SELECT 201 , POD.SET_OF_BOOKS_ID , POH.ORG_ID , OOD.ORGANIZATION_CODE, PLL.SHIP_TO_ORGANIZATION_ID, 'PURCHASES' , 'PO' , PL1.DISPLAYED_FIELD , PL1.LOOKUP_CODE, POH.SEGMENT1, POH.PO_HEADER_ID, POH.CREATION_DATE , POH.COMMENTS , 'PO', POH.PO_HEADER_ID, JEL.CODE_COMBINATION_ID, POH.CURRENCY_CODE , JEL.ENTERED_DR , JEL.ENTERED_CR , JEL.ACCOUNTED_DR , JEL.ACCOUNTED_CR , JEH.JE_HEADER_ID , JEL.JE_LINE_NUM , JEH.CURRENCY_CONVERSION_DATE , JEH.CURRENCY_CONVERSION_TYPE , GLCT.USER_CONVERSION_TYPE, JEH.CURRENCY_CONVERSION_RATE , JEL.EFFECTIVE_DATE , PL1.DISPLAYED_FIELD, RPAD(PL1.DISPLAYED_FIELD,80), POH.CREATION_DATE , POH.CREATED_BY , POH.LAST_UPDATE_DATE , POH.LAST_UPDATED_BY , POH.LAST_UPDATE_LOGIN , POH.REQUEST_ID , POH.PROGRAM_APPLICATION_ID , POH.PROGRAM_ID , POH.PROGRAM_UPDATE_DATE , POH.SEGMENT1 , PL1.DISPLAYED_FIELD, PR.RELEASE_NUM , POL.LINE_NUM , POL.ITEM_ID , POL.ITEM_REVISION , POL.ITEM_DESCRIPTION , POL.UNIT_MEAS_LOOKUP_CODE , POL.QUANTITY , POL.UNIT_PRICE , POD.DESTINATION_SUBINVENTORY FROM PO_LOOKUP_CODES PL1, PO_HEADERS_ALL POH, PO_LINES_ALL POL, PO_LINE_LOCATIONS_ALL PLL, PO_DISTRIBUTIONS_ALL POD, PO_RELEASES_ALL PR, ORG_ORGANIZATION_DEFINITIONS OOD, GL_JE_HEADERS JEH, GL_JE_LINES JEL, GL_DAILY_CONVERSION_TYPES GLCT WHERE PL1.LOOKUP_CODE = POH.TYPE_LOOKUP_CODE AND PL1.LOOKUP_TYPE = 'PO TYPE' AND POL.PO_HEADER_ID = POH.PO_HEADER_ID AND PLL.PO_HEADER_ID = POH.PO_HEADER_ID AND POL.PO_LINE_ID = PLL.PO_LINE_ID AND PLL.LINE_LOCATION_ID = POD.LINE_LOCATION_ID AND POD.PO_HEADER_ID = POH.PO_HEADER_ID AND PR.PO_RELEASE_ID(+) = PLL.PO_RELEASE_ID AND OOD.ORGANIZATION_ID = PLL.SHIP_TO_ORGANIZATION_ID AND OOD.SET_OF_BOOKS_ID = POD.SET_OF_BOOKS_ID AND JEL.JE_HEADER_ID = JEH.JE_HEADER_ID AND GLCT.CONVERSION_TYPE(+) = JEH.CURRENCY_CONVERSION_TYPE AND JEL.reference_2 = to_char(PLL.po_header_id) AND JEL.reference_3 = to_char(POD.po_distribution_id) AND JEL.reference_4 = POH.segment1 AND POD.SET_OF_BOOKS_ID= JEH.LEDGER_ID UNION ALL SELECT 201 , POMD.SET_OF_BOOKS_ID , POH.ORG_ID , OOD.ORGANIZATION_CODE, PLL.SHIP_TO_ORGANIZATION_ID, 'PURCHASES' , 'PO' , PL1.DISPLAYED_FIELD , PL1.LOOKUP_CODE, POH.SEGMENT1, POH.PO_HEADER_ID, POH.CREATION_DATE , POH.COMMENTS , 'PO', POH.PO_HEADER_ID, JEL.CODE_COMBINATION_ID, POH.CURRENCY_CODE , JEL.ENTERED_DR , JEL.ENTERED_CR , JEL.ACCOUNTED_DR , JEL.ACCOUNTED_CR , JEH.JE_HEADER_ID , JEL.JE_LINE_NUM , JEH.CURRENCY_CONVERSION_DATE , JEH.CURRENCY_CONVERSION_TYPE , GLCT.USER_CONVERSION_TYPE, JEH.CURRENCY_CONVERSION_RATE , JEL.EFFECTIVE_DATE , PL1.DISPLAYED_FIELD, RPAD(PL1.DISPLAYED_FIELD,80), POH.CREATION_DATE , POH.CREATED_BY , POH.LAST_UPDATE_DATE , POH.LAST_UPDATED_BY , POH.LAST_UPDATE_LOGIN , POH.REQUEST_ID , POH.PROGRAM_APPLICATION_ID , POH.PROGRAM_ID , POH.PROGRAM_UPDATE_DATE , POH.SEGMENT1 , PL1.DISPLAYED_FIELD, PR.RELEASE_NUM , POL.LINE_NUM , POL.ITEM_ID , POL.ITEM_REVISION , POL.ITEM_DESCRIPTION , POL.UNIT_MEAS_LOOKUP_CODE , POL.QUANTITY , POL.UNIT_PRICE , POD.DESTINATION_SUBINVENTORY FROM PO_LOOKUP_CODES PL1, PO_HEADERS_ALL POH, PO_LINES_ALL POL, PO_LINE_LOCATIONS_ALL PLL, PO_DISTRIBUTIONS_ALL POD, PO_MC_DISTRIBUTIONS POMD, PO_RELEASES_ALL PR, ORG_ORGANIZATION_DEFINITIONS OOD, GL_JE_HEADERS JEH, GL_JE_LINES JEL, GL_DAILY_CONVERSION_TYPES GLCT WHERE PL1.LOOKUP_CODE = POH.TYPE_LOOKUP_CODE AND PL1.LOOKUP_TYPE = 'PO TYPE' AND POL.PO_HEADER_ID = POH.PO_HEADER_ID AND PLL.PO_HEADER_ID = POH.PO_HEADER_ID AND POL.PO_LINE_ID = PLL.PO_LINE_ID AND PLL.LINE_LOCATION_ID = POD.LINE_LOCATION_ID AND POD.PO_HEADER_ID = POH.PO_HEADER_ID AND PR.PO_RELEASE_ID(+) = PLL.PO_RELEASE_ID AND OOD.ORGANIZATION_ID = PLL.SHIP_TO_ORGANIZATION_ID AND OOD.SET_OF_BOOKS_ID = POD.SET_OF_BOOKS_ID AND JEL.JE_HEADER_ID = JEH.JE_HEADER_ID AND GLCT.CONVERSION_TYPE(+) = JEH.CURRENCY_CONVERSION_TYPE AND JEL.REFERENCE_2 = to_char(PLL.PO_HEADER_ID) AND JEL.REFERENCE_3 = to_char(POD.PO_DISTRIBUTION_ID) AND JEL.REFERENCE_4 = POH.SEGMENT1 AND POMD.PO_DISTRIBUTION_ID = POD.PO_DISTRIBUTION_ID AND POMD.SET_OF_BOOKS_ID =JEH.LEDGER_ID

View Text - HTML Formatted

SELECT 201
, POD.SET_OF_BOOKS_ID
, POH.ORG_ID
, OOD.ORGANIZATION_CODE
, PLL.SHIP_TO_ORGANIZATION_ID
, 'PURCHASES'
, 'PO'
, PL1.DISPLAYED_FIELD
, PL1.LOOKUP_CODE
, POH.SEGMENT1
, POH.PO_HEADER_ID
, POH.CREATION_DATE
, POH.COMMENTS
, 'PO'
, POH.PO_HEADER_ID
, JEL.CODE_COMBINATION_ID
, POH.CURRENCY_CODE
, JEL.ENTERED_DR
, JEL.ENTERED_CR
, JEL.ACCOUNTED_DR
, JEL.ACCOUNTED_CR
, JEH.JE_HEADER_ID
, JEL.JE_LINE_NUM
, JEH.CURRENCY_CONVERSION_DATE
, JEH.CURRENCY_CONVERSION_TYPE
, GLCT.USER_CONVERSION_TYPE
, JEH.CURRENCY_CONVERSION_RATE
, JEL.EFFECTIVE_DATE
, PL1.DISPLAYED_FIELD
, RPAD(PL1.DISPLAYED_FIELD
, 80)
, POH.CREATION_DATE
, POH.CREATED_BY
, POH.LAST_UPDATE_DATE
, POH.LAST_UPDATED_BY
, POH.LAST_UPDATE_LOGIN
, POH.REQUEST_ID
, POH.PROGRAM_APPLICATION_ID
, POH.PROGRAM_ID
, POH.PROGRAM_UPDATE_DATE
, POH.SEGMENT1
, PL1.DISPLAYED_FIELD
, PR.RELEASE_NUM
, POL.LINE_NUM
, POL.ITEM_ID
, POL.ITEM_REVISION
, POL.ITEM_DESCRIPTION
, POL.UNIT_MEAS_LOOKUP_CODE
, POL.QUANTITY
, POL.UNIT_PRICE
, POD.DESTINATION_SUBINVENTORY
FROM PO_LOOKUP_CODES PL1
, PO_HEADERS_ALL POH
, PO_LINES_ALL POL
, PO_LINE_LOCATIONS_ALL PLL
, PO_DISTRIBUTIONS_ALL POD
, PO_RELEASES_ALL PR
, ORG_ORGANIZATION_DEFINITIONS OOD
, GL_JE_HEADERS JEH
, GL_JE_LINES JEL
, GL_DAILY_CONVERSION_TYPES GLCT
WHERE PL1.LOOKUP_CODE = POH.TYPE_LOOKUP_CODE
AND PL1.LOOKUP_TYPE = 'PO TYPE'
AND POL.PO_HEADER_ID = POH.PO_HEADER_ID
AND PLL.PO_HEADER_ID = POH.PO_HEADER_ID
AND POL.PO_LINE_ID = PLL.PO_LINE_ID
AND PLL.LINE_LOCATION_ID = POD.LINE_LOCATION_ID
AND POD.PO_HEADER_ID = POH.PO_HEADER_ID
AND PR.PO_RELEASE_ID(+) = PLL.PO_RELEASE_ID
AND OOD.ORGANIZATION_ID = PLL.SHIP_TO_ORGANIZATION_ID
AND OOD.SET_OF_BOOKS_ID = POD.SET_OF_BOOKS_ID
AND JEL.JE_HEADER_ID = JEH.JE_HEADER_ID
AND GLCT.CONVERSION_TYPE(+) = JEH.CURRENCY_CONVERSION_TYPE
AND JEL.REFERENCE_2 = TO_CHAR(PLL.PO_HEADER_ID)
AND JEL.REFERENCE_3 = TO_CHAR(POD.PO_DISTRIBUTION_ID)
AND JEL.REFERENCE_4 = POH.SEGMENT1
AND POD.SET_OF_BOOKS_ID= JEH.LEDGER_ID UNION ALL SELECT 201
, POMD.SET_OF_BOOKS_ID
, POH.ORG_ID
, OOD.ORGANIZATION_CODE
, PLL.SHIP_TO_ORGANIZATION_ID
, 'PURCHASES'
, 'PO'
, PL1.DISPLAYED_FIELD
, PL1.LOOKUP_CODE
, POH.SEGMENT1
, POH.PO_HEADER_ID
, POH.CREATION_DATE
, POH.COMMENTS
, 'PO'
, POH.PO_HEADER_ID
, JEL.CODE_COMBINATION_ID
, POH.CURRENCY_CODE
, JEL.ENTERED_DR
, JEL.ENTERED_CR
, JEL.ACCOUNTED_DR
, JEL.ACCOUNTED_CR
, JEH.JE_HEADER_ID
, JEL.JE_LINE_NUM
, JEH.CURRENCY_CONVERSION_DATE
, JEH.CURRENCY_CONVERSION_TYPE
, GLCT.USER_CONVERSION_TYPE
, JEH.CURRENCY_CONVERSION_RATE
, JEL.EFFECTIVE_DATE
, PL1.DISPLAYED_FIELD
, RPAD(PL1.DISPLAYED_FIELD
, 80)
, POH.CREATION_DATE
, POH.CREATED_BY
, POH.LAST_UPDATE_DATE
, POH.LAST_UPDATED_BY
, POH.LAST_UPDATE_LOGIN
, POH.REQUEST_ID
, POH.PROGRAM_APPLICATION_ID
, POH.PROGRAM_ID
, POH.PROGRAM_UPDATE_DATE
, POH.SEGMENT1
, PL1.DISPLAYED_FIELD
, PR.RELEASE_NUM
, POL.LINE_NUM
, POL.ITEM_ID
, POL.ITEM_REVISION
, POL.ITEM_DESCRIPTION
, POL.UNIT_MEAS_LOOKUP_CODE
, POL.QUANTITY
, POL.UNIT_PRICE
, POD.DESTINATION_SUBINVENTORY
FROM PO_LOOKUP_CODES PL1
, PO_HEADERS_ALL POH
, PO_LINES_ALL POL
, PO_LINE_LOCATIONS_ALL PLL
, PO_DISTRIBUTIONS_ALL POD
, PO_MC_DISTRIBUTIONS POMD
, PO_RELEASES_ALL PR
, ORG_ORGANIZATION_DEFINITIONS OOD
, GL_JE_HEADERS JEH
, GL_JE_LINES JEL
, GL_DAILY_CONVERSION_TYPES GLCT
WHERE PL1.LOOKUP_CODE = POH.TYPE_LOOKUP_CODE
AND PL1.LOOKUP_TYPE = 'PO TYPE'
AND POL.PO_HEADER_ID = POH.PO_HEADER_ID
AND PLL.PO_HEADER_ID = POH.PO_HEADER_ID
AND POL.PO_LINE_ID = PLL.PO_LINE_ID
AND PLL.LINE_LOCATION_ID = POD.LINE_LOCATION_ID
AND POD.PO_HEADER_ID = POH.PO_HEADER_ID
AND PR.PO_RELEASE_ID(+) = PLL.PO_RELEASE_ID
AND OOD.ORGANIZATION_ID = PLL.SHIP_TO_ORGANIZATION_ID
AND OOD.SET_OF_BOOKS_ID = POD.SET_OF_BOOKS_ID
AND JEL.JE_HEADER_ID = JEH.JE_HEADER_ID
AND GLCT.CONVERSION_TYPE(+) = JEH.CURRENCY_CONVERSION_TYPE
AND JEL.REFERENCE_2 = TO_CHAR(PLL.PO_HEADER_ID)
AND JEL.REFERENCE_3 = TO_CHAR(POD.PO_DISTRIBUTION_ID)
AND JEL.REFERENCE_4 = POH.SEGMENT1
AND POMD.PO_DISTRIBUTION_ID = POD.PO_DISTRIBUTION_ID
AND POMD.SET_OF_BOOKS_ID =JEH.LEDGER_ID