VIEW: APPS.PABV_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 , 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 , pea.document_distribution_type , pcdl.batch_name , pcdl.dr_code_combination_id , pcdl.cr_code_combination_id , pcdl.org_id , 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 , pcdl.acct_rate_date , pcdl.acct_exchange_rate , pcdl.project_currency_code , pcdl.project_rate_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 WHERE pcdl.expenditure_item_id = pea.expenditure_item_id and '_SEC:pcdl.org_id' is not null 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
, 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
, PEA.DOCUMENT_DISTRIBUTION_TYPE
, PCDL.BATCH_NAME
, PCDL.DR_CODE_COMBINATION_ID
, PCDL.CR_CODE_COMBINATION_ID
, PCDL.ORG_ID
, 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
, PCDL.ACCT_RATE_DATE
, PCDL.ACCT_EXCHANGE_RATE
, PCDL.PROJECT_CURRENCY_CODE
, PCDL.PROJECT_RATE_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
WHERE PCDL.EXPENDITURE_ITEM_ID = PEA.EXPENDITURE_ITEM_ID
AND '_SEC:PCDL.ORG_ID' IS NOT NULL WITH READ ONLY