VIEW: APPS.PA_RCV_EXCEPTIONS_DET_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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