VIEW: APPS.PSA_PO_ENC_GL_BC_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, POD.po_distribution_id, BCP.CODE_COMBINATION_ID, POH.CURRENCY_CODE , BCP.ENTERED_DR , BCP.ENTERED_CR , BCP.ACCOUNTED_DR , BCP.ACCOUNTED_CR , BCP.JE_HEADER_ID , BCP.JE_LINE_NUM , POH.RATE_DATE , POH.RATE_TYPE , GLCT.USER_CONVERSION_TYPE, POH.RATE , POD.GL_ENCUMBERED_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 POH, PO_LINES POL, PO_LINE_LOCATIONS PLL, PO_DISTRIBUTIONS POD, PO_RELEASES PR, ORG_ORGANIZATION_DEFINITIONS OOD, GL_BC_PACKETS BCP, 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 GLCT.CONVERSION_TYPE(+) = POH.RATE_TYPE AND BCP.reference2 = to_char(PLL.po_header_id) AND BCP.reference3 = to_char(POD.po_distribution_id) AND BCP.reference4 = POH.segment1 AND BCP.status_code = 'A'

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
, POD.PO_DISTRIBUTION_ID
, BCP.CODE_COMBINATION_ID
, POH.CURRENCY_CODE
, BCP.ENTERED_DR
, BCP.ENTERED_CR
, BCP.ACCOUNTED_DR
, BCP.ACCOUNTED_CR
, BCP.JE_HEADER_ID
, BCP.JE_LINE_NUM
, POH.RATE_DATE
, POH.RATE_TYPE
, GLCT.USER_CONVERSION_TYPE
, POH.RATE
, POD.GL_ENCUMBERED_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 POH
, PO_LINES POL
, PO_LINE_LOCATIONS PLL
, PO_DISTRIBUTIONS POD
, PO_RELEASES PR
, ORG_ORGANIZATION_DEFINITIONS OOD
, GL_BC_PACKETS BCP
, 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 GLCT.CONVERSION_TYPE(+) = POH.RATE_TYPE
AND BCP.REFERENCE2 = TO_CHAR(PLL.PO_HEADER_ID)
AND BCP.REFERENCE3 = TO_CHAR(POD.PO_DISTRIBUTION_ID)
AND BCP.REFERENCE4 = POH.SEGMENT1
AND BCP.STATUS_CODE = 'A'