VIEW: APPS.PAFV_COST_DISTRIBUTIONS

Source

View Text - Preformatted

SELECT pea.expenditure_item_id, pcdl.line_num, pcdl.amount, pcdl.quantity, pcdl.burdened_cost, '_LA:pcdl.billable_flag:FND_LOOKUPS:YES_NO:MEANING', '_LA:reversed_flag:FND_LOOKUPS:YES_NO:MEANING', pcdl.line_num_reversed, '_LA:line_type:PA_LOOKUPS:COST DISTRIBUTION LINE TYPE:MEANING', '_LA:transfer_status_code:PA_LOOKUPS:TRANSFER STATUS:MEANING', pa_date, gl_date, transferred_date, transfer_rejection_reason, pv.vendor_name, apid.base_amount, apid.amount, pea.vendor_id, pea.document_header_id ap_invoice_id, pea.document_distribution_id ap_invoice_distribution_id, pea.document_line_number ap_invoice_line_number, pea.document_payment_id ap_invoice_payment_id, pea.document_type document_type, pea.document_distribution_type document_distribution_type, /** **system_reference1, **system_reference2, **system_reference3, **/ pcdl.batch_name, pcdl.dr_code_combination_id, pcdl.cr_code_combination_id, pcdl.org_id, tl.name, pcdl.CREATION_DATE, pcdl.CREATED_BY, pcdl.denom_currency_code, pcdl.denom_raw_cost, pcdl.denom_burdened_cost, pcdl.acct_currency_code, pcdl.acct_raw_cost, pcdl.acct_burdened_cost, pcdl.acct_rate_type, pct.user_conversion_type, pcdl.acct_rate_date, pcdl.acct_exchange_rate, pcdl.project_currency_code, pcdl.project_rate_type, pct1.user_conversion_type, pcdl.project_rate_date, pcdl.project_exchange_rate, pcdl.si_assets_addition_flag FROM pa_cost_distribution_lines_all pcdl, pa_expenditure_items_all pea, hr_all_organization_units hro, hr_all_organization_units_tl tl, po_vendors pv, ap_invoice_distributions_all apid, pa_conversion_types_v pct, pa_conversion_types_v pct1 WHERE pcdl.expenditure_item_id = pea.expenditure_item_id and '_SEC:pcdl.org_id' is not null and pcdl.org_id=hro.organization_id (+) and pcdl.org_id=tl.organization_id (+) and tl.language (+) = userenv('LANG') and pea.vendor_id = pv.vendor_id(+) and pea.document_distribution_id = apid.invoice_distribution_id(+) and pea.document_header_id = apid.invoice_id(+) and pcdl.acct_rate_type = pct.conversion_type(+) and pcdl.project_rate_type = pct1.conversion_type(+) WITH READ ONLY

View Text - HTML Formatted

SELECT PEA.EXPENDITURE_ITEM_ID
, PCDL.LINE_NUM
, PCDL.AMOUNT
, PCDL.QUANTITY
, PCDL.BURDENED_COST
, '_LA:PCDL.BILLABLE_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_LA:REVERSED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, PCDL.LINE_NUM_REVERSED
, '_LA:LINE_TYPE:PA_LOOKUPS:COST DISTRIBUTION LINE TYPE:MEANING'
, '_LA:TRANSFER_STATUS_CODE:PA_LOOKUPS:TRANSFER STATUS:MEANING'
, PA_DATE
, GL_DATE
, TRANSFERRED_DATE
, TRANSFER_REJECTION_REASON
, PV.VENDOR_NAME
, APID.BASE_AMOUNT
, APID.AMOUNT
, PEA.VENDOR_ID
, PEA.DOCUMENT_HEADER_ID AP_INVOICE_ID
, PEA.DOCUMENT_DISTRIBUTION_ID AP_INVOICE_DISTRIBUTION_ID
, PEA.DOCUMENT_LINE_NUMBER AP_INVOICE_LINE_NUMBER
, PEA.DOCUMENT_PAYMENT_ID AP_INVOICE_PAYMENT_ID
, PEA.DOCUMENT_TYPE DOCUMENT_TYPE
, PEA.DOCUMENT_DISTRIBUTION_TYPE DOCUMENT_DISTRIBUTION_TYPE
, /** **SYSTEM_REFERENCE1
, **SYSTEM_REFERENCE2
, **SYSTEM_REFERENCE3
, **/ PCDL.BATCH_NAME
, PCDL.DR_CODE_COMBINATION_ID
, PCDL.CR_CODE_COMBINATION_ID
, PCDL.ORG_ID
, TL.NAME
, PCDL.CREATION_DATE
, PCDL.CREATED_BY
, PCDL.DENOM_CURRENCY_CODE
, PCDL.DENOM_RAW_COST
, PCDL.DENOM_BURDENED_COST
, PCDL.ACCT_CURRENCY_CODE
, PCDL.ACCT_RAW_COST
, PCDL.ACCT_BURDENED_COST
, PCDL.ACCT_RATE_TYPE
, PCT.USER_CONVERSION_TYPE
, PCDL.ACCT_RATE_DATE
, PCDL.ACCT_EXCHANGE_RATE
, PCDL.PROJECT_CURRENCY_CODE
, PCDL.PROJECT_RATE_TYPE
, PCT1.USER_CONVERSION_TYPE
, PCDL.PROJECT_RATE_DATE
, PCDL.PROJECT_EXCHANGE_RATE
, PCDL.SI_ASSETS_ADDITION_FLAG
FROM PA_COST_DISTRIBUTION_LINES_ALL PCDL
, PA_EXPENDITURE_ITEMS_ALL PEA
, HR_ALL_ORGANIZATION_UNITS HRO
, HR_ALL_ORGANIZATION_UNITS_TL TL
, PO_VENDORS PV
, AP_INVOICE_DISTRIBUTIONS_ALL APID
, PA_CONVERSION_TYPES_V PCT
, PA_CONVERSION_TYPES_V PCT1
WHERE PCDL.EXPENDITURE_ITEM_ID = PEA.EXPENDITURE_ITEM_ID
AND '_SEC:PCDL.ORG_ID' IS NOT NULL
AND PCDL.ORG_ID=HRO.ORGANIZATION_ID (+)
AND PCDL.ORG_ID=TL.ORGANIZATION_ID (+)
AND TL.LANGUAGE (+) = USERENV('LANG')
AND PEA.VENDOR_ID = PV.VENDOR_ID(+)
AND PEA.DOCUMENT_DISTRIBUTION_ID = APID.INVOICE_DISTRIBUTION_ID(+)
AND PEA.DOCUMENT_HEADER_ID = APID.INVOICE_ID(+)
AND PCDL.ACCT_RATE_TYPE = PCT.CONVERSION_TYPE(+)
AND PCDL.PROJECT_RATE_TYPE = PCT1.CONVERSION_TYPE(+) WITH READ ONLY