VIEW: APPS.PSA_REQ_ENC_GL_BC_V

Source

View Text - Preformatted

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, PRD.distribution_id, bcp.CODE_COMBINATION_ID, PRL.CURRENCY_CODE , bcp.ENTERED_DR , bcp.ENTERED_CR , bcp.ACCOUNTED_DR , bcp.ACCOUNTED_CR , bcp.JE_HEADER_ID , bcp.JE_LINE_NUM , PRL.RATE_DATE , PRL.RATE_TYPE , GLCT.USER_CONVERSION_TYPE, PRL.RATE , PRD.GL_ENCUMBERED_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_ALL PRH, PO_REQUISITION_LINES_ALL PRL, PO_REQ_DISTRIBUTIONS_ALL PRD, ORG_ORGANIZATION_DEFINITIONS OOD, GL_BC_PACKETS bcp, 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 GLCT.CONVERSION_TYPE(+) = PRL.RATE_TYPE AND bcp.reference2 = to_char(PRL.REQUISITION_HEADER_ID) AND bcp.reference3 = to_char(PRD.distribution_id) AND bcp.reference4 = PRH.segment1 AND bcp.status_code IN ('A','P')

View Text - HTML Formatted

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
, PRD.DISTRIBUTION_ID
, BCP.CODE_COMBINATION_ID
, PRL.CURRENCY_CODE
, BCP.ENTERED_DR
, BCP.ENTERED_CR
, BCP.ACCOUNTED_DR
, BCP.ACCOUNTED_CR
, BCP.JE_HEADER_ID
, BCP.JE_LINE_NUM
, PRL.RATE_DATE
, PRL.RATE_TYPE
, GLCT.USER_CONVERSION_TYPE
, PRL.RATE
, PRD.GL_ENCUMBERED_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_ALL PRH
, PO_REQUISITION_LINES_ALL PRL
, PO_REQ_DISTRIBUTIONS_ALL PRD
, ORG_ORGANIZATION_DEFINITIONS OOD
, GL_BC_PACKETS BCP
, 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 GLCT.CONVERSION_TYPE(+) = PRL.RATE_TYPE
AND BCP.REFERENCE2 = TO_CHAR(PRL.REQUISITION_HEADER_ID)
AND BCP.REFERENCE3 = TO_CHAR(PRD.DISTRIBUTION_ID)
AND BCP.REFERENCE4 = PRH.SEGMENT1
AND BCP.STATUS_CODE IN ('A'
, 'P')