Product: | PA - Projects |
---|---|
Description: | Pa_rcv_exceptions_det_v is a view that identifies the receipts that prevent a period from being closed |
Implementation/DBA Data: | APPS.PA_RCV_EXCEPTIONS_DET_V |
SELECT SMRY.PROJECT_ID PROJECT_ID
, PRJ.SEGMENT1 PROJECT_NUMBER
, SMRY.TASK_ID TASK_ID
, TSK.TASK_NUMBER TASK_NUMBER
, SMRY.RCV_TRANSACTION_ID RCV_TRANSACTION_ID
, HDR.RECEIPT_NUM RECEIPT_NUMBER
, SMRY.VENDOR_ID VENDOR_ID
, VND.SEGMENT1 VENDOR_NUMBER
, VND.VENDOR_NAME VENDOR_NAME
, SMRY.EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, SMRY.EXPENDITURE_TYPE EXPENDITURE_TYPE
, SMRY.DENOM_CURRENCY_CODE DENOM_CURRENCY_CODE
, SMRY.DENOM_AMOUNT DENOM_AMOUNT
, SMRY.ACCT_CURRENCY_CODE ACCT_CURRENCY_CODE
, SMRY.AMOUNT AMOUNT
, SMRY.ACCT_RATE_DATE ACCT_RATE_DATE
, SMRY.ACCT_RATE_TYPE ACCT_RATE_TYPE
, SMRY.ACCT_EXCHANGE_RATE ACCT_EXCHANGE_RATE
, SMRY.PA_DATE PA_DATE
, SMRY.PERIOD_NAME PERIOD_NAME
, SMRY.GL_DATE GL_DATE
, SMRY.GL_PERIOD_NAME GL_PERIOD_NAME
, SMRY.EXCEPTION_CODE EXCEPTION_CODE
, SMRY.EXCEPTION_REASON EXCEPTION_REASON
, SMRY.CORRECTIVE_ACTION CORRECTIVE_ACTION
, SMRY.ORG_ID
, SMRY.SAME_PA_GL_PERIOD
, SMRY.SET_OF_BOOKS_ID
, PO_HDR.SEGMENT1
, PO_LINE.LINE_NUM
, PO_SHIP.SHIPMENT_NUM
, SMRY.DISTRIBUTION_NUM
, SMRY.OU_NAME
FROM PA_RCV_EXCEPTIONS_SUM_V SMRY
, PA_PROJECTS_ALL PRJ
, PA_TASKS TSK
, PO_VENDORS VND
, RCV_SHIPMENT_HEADERS HDR
, PO_HEADERS_ALL PO_HDR
, PO_LINES_ALL PO_LINE
, PO_LINE_LOCATIONS_ALL PO_SHIP
WHERE PRJ.PROJECT_ID = SMRY.PROJECT_ID
AND TSK.TASK_ID = SMRY.TASK_ID
AND VND.VENDOR_ID = SMRY.VENDOR_ID
AND HDR.SHIPMENT_HEADER_ID = SMRY.SHIPMENT_HEADER_ID
AND PO_HDR.PO_HEADER_ID = SMRY.PO_HEADER_ID
AND PO_LINE.PO_LINE_ID = SMRY.PO_LINE_ID
AND PO_SHIP.LINE_LOCATION_ID = SMRY.PO_LINE_LOCATION_ID