View: REQ_ENC_AEL_GL_V

Product:	PO - Purchasing
Description:
Implementation/DBA Data:	APPS.REQ_ENC_AEL_GL_V

View Text

SELECT 201
, PRD.SET_OF_BOOKS_ID
, PRH.ORG_ID
, OOD.ORGANIZATION_CODE
, PRL.DESTINATION_ORGANIZATION_ID
, 'REQUISITIONS'
, 'REQ'
, PL1.DISPLAYED_FIELD
, PL1.LOOKUP_CODE
, PRH.SEGMENT1
, PRH.REQUISITION_HEADER_ID
, PRH.CREATION_DATE
, PRH.DESCRIPTION
, 'REQ'
, PRH.REQUISITION_HEADER_ID
, JEL.CODE_COMBINATION_ID
, PRL.CURRENCY_CODE
, JEL.ENTERED_DR
, JEL.ENTERED_CR
, JEL.ACCOUNTED_DR
, JEL.ACCOUNTED_CR
, JEL.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)
, PRH.CREATION_DATE
, PRH.CREATED_BY
, PRH.LAST_UPDATE_DATE
, PRH.LAST_UPDATED_BY
, PRH.LAST_UPDATE_LOGIN
, PRH.REQUEST_ID
, PRH.PROGRAM_APPLICATION_ID
, PRH.PROGRAM_ID
, PRH.PROGRAM_UPDATE_DATE
, PRH.SEGMENT1
, PL1.DISPLAYED_FIELD
, PRL.LINE_NUM
, PRL.ITEM_ID
, PRL.ITEM_REVISION
, PRL.ITEM_DESCRIPTION
, PRL.UNIT_MEAS_LOOKUP_CODE
, PRL.QUANTITY
, PRL.UNIT_PRICE
, PRL.DESTINATION_SUBINVENTORY
FROM PO_LOOKUP_CODES PL1
, PO_REQUISITION_HEADERS PRH
, PO_REQUISITION_LINES PRL
, PO_REQ_DISTRIBUTIONS PRD
, ORG_ORGANIZATION_DEFINITIONS OOD
, GL_JE_HEADERS JEH
, GL_JE_LINES JEL
, GL_DAILY_CONVERSION_TYPES GLCT
WHERE PL1.LOOKUP_CODE = PRH.TYPE_LOOKUP_CODE
AND PL1.LOOKUP_TYPE = 'REQUISITION TYPE'
AND PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
AND PRL.REQUISITION_LINE_ID = PRD.REQUISITION_LINE_ID
AND OOD.ORGANIZATION_ID = PRL.DESTINATION_ORGANIZATION_ID
AND OOD.SET_OF_BOOKS_ID = PRD.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 = PRL.REQUISITION_HEADER_ID
AND JEL.REFERENCE_3 = PRD.DISTRIBUTION_ID
AND JEL.REFERENCE_4 = PRH.SEGMENT1

Columns