VIEW: APPS.PA_FC_ACTUAL_DTLS_V

Source

View Text - Preformatted

SELECT ei.expenditure_item_id , ei.project_id , ei.task_id , pt.task_number , ei.expenditure_type , pet.expenditure_category , ei.expenditure_item_date , pv.vendor_name supplier_name , ei.transaction_source , ei.quantity , ei.denom_raw_cost , ei.denom_burdened_cost , ei.denom_currency_code , ei.project_raw_cost , ei.project_burdened_cost , ei.project_currency_code , ei.project_rate_type , ei.project_rate_date , ei.project_exchange_rate , ei.acct_raw_cost , ei.acct_burdened_cost , ei.acct_currency_code , ei.acct_rate_date , ei.acct_rate_type , ei.acct_exchange_rate , cdl.projfunc_currency_code , cdl.projfunc_cost_rate_type , cdl.projfunc_cost_rate_date , cdl.projfunc_cost_exchange_rate , cdl.pa_date , cdl.pa_period_name , cdl.gl_date , cdl.gl_period_name , api.invoice_num document_name , ei.document_header_id , apl.line_number document_line_num , ei.document_line_number , apd.distribution_line_number document_distribution_number , ei.document_distribution_id , ei.vendor_id supplier_id FROM pa_expenditure_items ei , pa_cost_distribution_lines cdl , po_vendors pv , pa_tasks pt , ap_invoice_distributions apd , ap_invoices api , ap_invoice_lines apl , pa_expenditure_types pet WHERE ei.expenditure_item_id = cdl.expenditure_item_id AND ei.vendor_id = pv.vendor_id AND ei.expenditure_type = pet.expenditure_type AND ei.document_header_id = apd.invoice_id AND ei.document_distribution_id = apd.invoice_distribution_id AND ei.document_header_id = api.invoice_id AND api.invoice_id = apd.invoice_id AND apl.invoice_id = apd.invoice_id AND apl.invoice_id = api.invoice_id AND apl.line_number = apd.invoice_line_number AND cdl.line_num = 1 AND ei.system_linkage_function = 'VI' AND cdl.transfer_status_code = 'V' AND ei.task_id = pt.task_id AND ei.transaction_source IN ('AP INVOICE', 'INTERCOMPANY_AP_INVOICES', 'INTERPROJECT_AP_INVOICES' , 'AP NRTAX', 'AP VARIANCE', 'AP DISCOUNT' , 'AP ERV', 'AP SELF ASSESSED TAX') UNION ALL SELECT ei.expenditure_item_id , ei.project_id , ei.task_id , pt.task_number , ei.expenditure_type , pet.expenditure_category , ei.expenditure_item_date , pv.vendor_name supplier_name , ei.transaction_source , ei.quantity , ei.denom_raw_cost , ei.denom_burdened_cost , ei.denom_currency_code , ei.project_raw_cost , ei.project_burdened_cost , ei.project_currency_code , ei.project_rate_type , ei.project_rate_date , ei.project_exchange_rate , ei.acct_raw_cost , ei.acct_burdened_cost , ei.acct_currency_code , ei.acct_rate_date , ei.acct_rate_type , ei.acct_exchange_rate , cdl.projfunc_currency_code , cdl.projfunc_cost_rate_type , cdl.projfunc_cost_rate_date , cdl.projfunc_cost_exchange_rate , cdl.pa_date , cdl.pa_period_name , cdl.gl_date , cdl.gl_period_name , poh.segment1 document_name , ei.document_header_id , pol.line_num document_line_num , ei.document_line_number , pod.distribution_num document_distribution_number , ei.document_distribution_id , ei.vendor_id FROM pa_expenditure_items ei , pa_cost_distribution_lines cdl , po_vendors pv , pa_tasks pt , po_distributions pod , po_headers poh , po_lines pol , pa_expenditure_types pet WHERE ei.expenditure_item_id = cdl.expenditure_item_id AND ei.expenditure_type = pet.expenditure_type AND ei.vendor_id = pv.vendor_id AND ei.document_header_id = poh.po_header_id AND ei.document_line_number = pod.po_distribution_id AND ei.document_header_id = pod.po_header_id AND poh.po_header_id = pod.po_header_id AND ei.system_linkage_function = 'VI' AND cdl.transfer_status_code = 'V' AND pol.po_line_id = pod.po_line_id AND pol.po_header_id = poh.po_header_id AND pol.po_header_id = pod.po_header_id AND ei.task_id = pt.task_id AND cdl.line_num = 1 AND ei.transaction_source IN ('PO RECEIPT', 'PO RECEIPT NRTAX', 'PO RECEIPT NRTAX PRICE ADJ' , 'PO RECEIPT PRICE ADJ')

View Text - HTML Formatted

SELECT EI.EXPENDITURE_ITEM_ID
, EI.PROJECT_ID
, EI.TASK_ID
, PT.TASK_NUMBER
, EI.EXPENDITURE_TYPE
, PET.EXPENDITURE_CATEGORY
, EI.EXPENDITURE_ITEM_DATE
, PV.VENDOR_NAME SUPPLIER_NAME
, EI.TRANSACTION_SOURCE
, EI.QUANTITY
, EI.DENOM_RAW_COST
, EI.DENOM_BURDENED_COST
, EI.DENOM_CURRENCY_CODE
, EI.PROJECT_RAW_COST
, EI.PROJECT_BURDENED_COST
, EI.PROJECT_CURRENCY_CODE
, EI.PROJECT_RATE_TYPE
, EI.PROJECT_RATE_DATE
, EI.PROJECT_EXCHANGE_RATE
, EI.ACCT_RAW_COST
, EI.ACCT_BURDENED_COST
, EI.ACCT_CURRENCY_CODE
, EI.ACCT_RATE_DATE
, EI.ACCT_RATE_TYPE
, EI.ACCT_EXCHANGE_RATE
, CDL.PROJFUNC_CURRENCY_CODE
, CDL.PROJFUNC_COST_RATE_TYPE
, CDL.PROJFUNC_COST_RATE_DATE
, CDL.PROJFUNC_COST_EXCHANGE_RATE
, CDL.PA_DATE
, CDL.PA_PERIOD_NAME
, CDL.GL_DATE
, CDL.GL_PERIOD_NAME
, API.INVOICE_NUM DOCUMENT_NAME
, EI.DOCUMENT_HEADER_ID
, APL.LINE_NUMBER DOCUMENT_LINE_NUM
, EI.DOCUMENT_LINE_NUMBER
, APD.DISTRIBUTION_LINE_NUMBER DOCUMENT_DISTRIBUTION_NUMBER
, EI.DOCUMENT_DISTRIBUTION_ID
, EI.VENDOR_ID SUPPLIER_ID
FROM PA_EXPENDITURE_ITEMS EI
, PA_COST_DISTRIBUTION_LINES CDL
, PO_VENDORS PV
, PA_TASKS PT
, AP_INVOICE_DISTRIBUTIONS APD
, AP_INVOICES API
, AP_INVOICE_LINES APL
, PA_EXPENDITURE_TYPES PET
WHERE EI.EXPENDITURE_ITEM_ID = CDL.EXPENDITURE_ITEM_ID
AND EI.VENDOR_ID = PV.VENDOR_ID
AND EI.EXPENDITURE_TYPE = PET.EXPENDITURE_TYPE
AND EI.DOCUMENT_HEADER_ID = APD.INVOICE_ID
AND EI.DOCUMENT_DISTRIBUTION_ID = APD.INVOICE_DISTRIBUTION_ID
AND EI.DOCUMENT_HEADER_ID = API.INVOICE_ID
AND API.INVOICE_ID = APD.INVOICE_ID
AND APL.INVOICE_ID = APD.INVOICE_ID
AND APL.INVOICE_ID = API.INVOICE_ID
AND APL.LINE_NUMBER = APD.INVOICE_LINE_NUMBER
AND CDL.LINE_NUM = 1
AND EI.SYSTEM_LINKAGE_FUNCTION = 'VI'
AND CDL.TRANSFER_STATUS_CODE = 'V'
AND EI.TASK_ID = PT.TASK_ID
AND EI.TRANSACTION_SOURCE IN ('AP INVOICE'
, 'INTERCOMPANY_AP_INVOICES'
, 'INTERPROJECT_AP_INVOICES'
, 'AP NRTAX'
, 'AP VARIANCE'
, 'AP DISCOUNT'
, 'AP ERV'
, 'AP SELF ASSESSED TAX') UNION ALL SELECT EI.EXPENDITURE_ITEM_ID
, EI.PROJECT_ID
, EI.TASK_ID
, PT.TASK_NUMBER
, EI.EXPENDITURE_TYPE
, PET.EXPENDITURE_CATEGORY
, EI.EXPENDITURE_ITEM_DATE
, PV.VENDOR_NAME SUPPLIER_NAME
, EI.TRANSACTION_SOURCE
, EI.QUANTITY
, EI.DENOM_RAW_COST
, EI.DENOM_BURDENED_COST
, EI.DENOM_CURRENCY_CODE
, EI.PROJECT_RAW_COST
, EI.PROJECT_BURDENED_COST
, EI.PROJECT_CURRENCY_CODE
, EI.PROJECT_RATE_TYPE
, EI.PROJECT_RATE_DATE
, EI.PROJECT_EXCHANGE_RATE
, EI.ACCT_RAW_COST
, EI.ACCT_BURDENED_COST
, EI.ACCT_CURRENCY_CODE
, EI.ACCT_RATE_DATE
, EI.ACCT_RATE_TYPE
, EI.ACCT_EXCHANGE_RATE
, CDL.PROJFUNC_CURRENCY_CODE
, CDL.PROJFUNC_COST_RATE_TYPE
, CDL.PROJFUNC_COST_RATE_DATE
, CDL.PROJFUNC_COST_EXCHANGE_RATE
, CDL.PA_DATE
, CDL.PA_PERIOD_NAME
, CDL.GL_DATE
, CDL.GL_PERIOD_NAME
, POH.SEGMENT1 DOCUMENT_NAME
, EI.DOCUMENT_HEADER_ID
, POL.LINE_NUM DOCUMENT_LINE_NUM
, EI.DOCUMENT_LINE_NUMBER
, POD.DISTRIBUTION_NUM DOCUMENT_DISTRIBUTION_NUMBER
, EI.DOCUMENT_DISTRIBUTION_ID
, EI.VENDOR_ID
FROM PA_EXPENDITURE_ITEMS EI
, PA_COST_DISTRIBUTION_LINES CDL
, PO_VENDORS PV
, PA_TASKS PT
, PO_DISTRIBUTIONS POD
, PO_HEADERS POH
, PO_LINES POL
, PA_EXPENDITURE_TYPES PET
WHERE EI.EXPENDITURE_ITEM_ID = CDL.EXPENDITURE_ITEM_ID
AND EI.EXPENDITURE_TYPE = PET.EXPENDITURE_TYPE
AND EI.VENDOR_ID = PV.VENDOR_ID
AND EI.DOCUMENT_HEADER_ID = POH.PO_HEADER_ID
AND EI.DOCUMENT_LINE_NUMBER = POD.PO_DISTRIBUTION_ID
AND EI.DOCUMENT_HEADER_ID = POD.PO_HEADER_ID
AND POH.PO_HEADER_ID = POD.PO_HEADER_ID
AND EI.SYSTEM_LINKAGE_FUNCTION = 'VI'
AND CDL.TRANSFER_STATUS_CODE = 'V'
AND POL.PO_LINE_ID = POD.PO_LINE_ID
AND POL.PO_HEADER_ID = POH.PO_HEADER_ID
AND POL.PO_HEADER_ID = POD.PO_HEADER_ID
AND EI.TASK_ID = PT.TASK_ID
AND CDL.LINE_NUM = 1
AND EI.TRANSACTION_SOURCE IN ('PO RECEIPT'
, 'PO RECEIPT NRTAX'
, 'PO RECEIPT NRTAX PRICE ADJ'
, 'PO RECEIPT PRICE ADJ')