VIEW: APPS.PABV_COMMITMENTS

Source

View Text - Preformatted

SELECT pc.cmt_line_id , '_LA:pc.transaction_source:PA_LOOKUPS:COMMITMENT TXN SOURCE:MEANING' , pc.cmt_number , pc.expenditure_item_date , pc.tot_cmt_raw_cost , pc.tot_cmt_burdened_cost , pc.tot_cmt_quantity , pc.description , pc.cmt_line_number , '_LA:pc.line_type:PA_LOOKUPS:COMMITMENT LINE TYPE:MEANING' , pc.cmt_creation_date , pc.cmt_approved_date , '_LA:pc.cmt_approved_flag:FND_LOOKUPS:YES_NO:MEANING' , pc.cmt_promised_date , pc.cmt_need_by_date , pc.project_id , pc.task_id , pc.expenditure_type , pc.organization_id , pc.LAST_UPDATE_DATE , pc.LAST_UPDATED_BY , pc.CREATION_DATE , pc.CREATED_BY , pc.receipt_currency_code , pc.receipt_currency_amount , pc.receipt_exchange_rate , pc.denom_currency_code , pc.denom_raw_cost , pc.denom_burdened_cost , pc.acct_currency_code , pc.acct_raw_cost , pc.acct_burdened_cost , pc.acct_rate_date , pc.acct_rate_type , pc.acct_exchange_rate , pc.project_currency_code , pc.project_rate_date , pc.project_rate_type , pc.project_exchange_rate , pc.cmt_distribution_id FROM pa_commitment_txns pc , pa_projects_all ppa WHERE pc.project_id = ppa.project_id and '_SEC:ppa.org_id' is not null WITH READ ONLY

View Text - HTML Formatted

SELECT PC.CMT_LINE_ID
, '_LA:PC.TRANSACTION_SOURCE:PA_LOOKUPS:COMMITMENT TXN SOURCE:MEANING'
, PC.CMT_NUMBER
, PC.EXPENDITURE_ITEM_DATE
, PC.TOT_CMT_RAW_COST
, PC.TOT_CMT_BURDENED_COST
, PC.TOT_CMT_QUANTITY
, PC.DESCRIPTION
, PC.CMT_LINE_NUMBER
, '_LA:PC.LINE_TYPE:PA_LOOKUPS:COMMITMENT LINE TYPE:MEANING'
, PC.CMT_CREATION_DATE
, PC.CMT_APPROVED_DATE
, '_LA:PC.CMT_APPROVED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, PC.CMT_PROMISED_DATE
, PC.CMT_NEED_BY_DATE
, PC.PROJECT_ID
, PC.TASK_ID
, PC.EXPENDITURE_TYPE
, PC.ORGANIZATION_ID
, PC.LAST_UPDATE_DATE
, PC.LAST_UPDATED_BY
, PC.CREATION_DATE
, PC.CREATED_BY
, PC.RECEIPT_CURRENCY_CODE
, PC.RECEIPT_CURRENCY_AMOUNT
, PC.RECEIPT_EXCHANGE_RATE
, PC.DENOM_CURRENCY_CODE
, PC.DENOM_RAW_COST
, PC.DENOM_BURDENED_COST
, PC.ACCT_CURRENCY_CODE
, PC.ACCT_RAW_COST
, PC.ACCT_BURDENED_COST
, PC.ACCT_RATE_DATE
, PC.ACCT_RATE_TYPE
, PC.ACCT_EXCHANGE_RATE
, PC.PROJECT_CURRENCY_CODE
, PC.PROJECT_RATE_DATE
, PC.PROJECT_RATE_TYPE
, PC.PROJECT_EXCHANGE_RATE
, PC.CMT_DISTRIBUTION_ID
FROM PA_COMMITMENT_TXNS PC
, PA_PROJECTS_ALL PPA
WHERE PC.PROJECT_ID = PPA.PROJECT_ID
AND '_SEC:PPA.ORG_ID' IS NOT NULL WITH READ ONLY