View: PA_RCV_EXCEPTIONS_SUM_V

Product:	PA - Projects
Description:	PA_RCV_EXCEPTIONS_SUM_V is a view that summarizes the Purchasing Receipts that prevent a period from being closed.
Implementation/DBA Data:	APPS.PA_RCV_EXCEPTIONS_SUM_V

View Text

SELECT PODIST.PROJECT_ID
, PODIST.TASK_ID
, RCV.TRANSACTION_ID
, RCV.SHIPMENT_HEADER_ID
, RCV.VENDOR_ID
, RCV.CURRENCY_CODE
, RCV_SUB.ENTERED_DR
, RCV_SUB.FUNCTIONAL_CURRENCY_CODE
, RCV_SUB.ACCOUNTED_DR
, RCV.CURRENCY_CONVERSION_DATE
, RCV.CURRENCY_CONVERSION_TYPE
, RCV.CURRENCY_CONVERSION_RATE
, RCV_SUB.PA_ADDITION_FLAG EXCEPTION_CODE
, PODIST.EXPENDITURE_ORGANIZATION_ID
, PODIST.EXPENDITURE_TYPE
, PODIST.EXPENDITURE_ITEM_DATE
, RCV.TRANSACTION_DATE GL_DATE
, PA_UTILS.GET_PA_DATE(PODIST.EXPENDITURE_ITEM_DATE
, RCV.TRANSACTION_DATE) PA_DATE
, PA_UTILS.GET_PA_PERIOD_NAME(PODIST.EXPENDITURE_ITEM_DATE
, RCV.TRANSACTION_DATE) PERIOD_NAME
, RCV_SUB.PERIOD_NAME GL_PERIOD_NAME
, PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('RECEIPT_EXCP'
, RCV_SUB.PA_ADDITION_FLAG
, NULL
, 'R') EXCEPTION_REASON
, PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT('RECEIPT_EXCP'
, RCV_SUB.PA_ADDITION_FLAG
, NULL
, 'A') CORRECTIVE_ACTION
, PODIST.ORG_ID
, IMP.SAME_PA_GL_PERIOD
, PA_EXPENDITURES_UTILS.GETORGTLNAME(PODIST.ORG_ID)
, IMP.SET_OF_BOOKS_ID
, RCV.PO_HEADER_ID
, RCV.PO_LINE_ID
, RCV.PO_LINE_LOCATION_ID
, PODIST.PO_DISTRIBUTION_ID
, PODIST.DISTRIBUTION_NUM
FROM PO_DISTRIBUTIONS_ALL PODIST
, RCV_TRANSACTIONS RCV
, PA_IMPLEMENTATIONS_ALL IMP
, RCV_RECEIVING_SUB_LEDGER RCV_SUB
, RCV_SHIPMENT_HEADERS RCV_HDR
WHERE RCV_SUB.PA_ADDITION_FLAG IN ('N'
, 'I')
AND ((RCV.DESTINATION_TYPE_CODE='EXPENSE'
AND RCV.TRANSACTION_TYPE <> 'RETURN TO RECEIVING'
AND RCV_SUB.ENTERED_DR IS NOT NULL) OR (RCV.DESTINATION_TYPE_CODE = 'RECEIVING'
AND RCV.TRANSACTION_TYPE IN ('RETURN TO RECEIVING'
, 'RETURN TO VENDOR')
AND RCV_SUB.ENTERED_CR IS NOT NULL) )
AND PODIST.PROJECT_ID IS NOT NULL
AND PODIST.DESTINATION_TYPE_CODE ='EXPENSE'
AND RCV_SUB.ACTUAL_FLAG = 'A'
AND PODIST.ACCRUE_ON_RECEIPT_FLAG= 'Y'
AND RCV.TRANSACTION_ID=RCV_SUB.RCV_TRANSACTION_ID
AND RCV_SUB.CODE_COMBINATION_ID = PODIST.CODE_COMBINATION_ID
AND NVL(PODIST.ORG_ID
, -99) = IMP.ORG_ID
AND RCV.PO_DISTRIBUTION_ID=PODIST.PO_DISTRIBUTION_ID
AND RCV.SHIPMENT_HEADER_ID = RCV_HDR.SHIPMENT_HEADER_ID

Columns