View: PAFV_COST_DISTRIBUTIONS

Product:	PA - Projects
Description:	Business view to show information about cost distribution lines.
Implementation/DBA Data:	APPS.PAFV_COST_DISTRIBUTIONS

View Text

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

Columns