VIEW: APPS.PAFV_COMMITMENTS

Source

View Text - Preformatted

SELECT pc.cmt_line_id , 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 , cmt_creation_date , cmt_approved_date , cmt_promised_date , cmt_need_by_date , pc.project_id , ppa.name , ppa.segment1 , pc.task_id , pt.task_name , pt.task_number , pc.expenditure_type , ppa.org_id , pc.organization_id , t.name , 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 , pct.user_conversion_type , pc.acct_exchange_rate , pc.project_currency_code , pc.project_rate_date , pc.project_rate_type , pct1.user_conversion_type , pc.project_exchange_rate , '_LA:transaction_source:PA_LOOKUPS:COMMITMENT TXN SOURCE:MEANING' , '_LA:line_type:PA_LOOKUPS:COMMITMENT LINE TYPE:MEANING' , '_LA:cmt_approved_flag:FND_LOOKUPS:YES_NO:MEANING' , pc.cmt_distribution_id FROM pa_commitment_txns pc , pa_projects_all ppa , pa_tasks pt , hr_all_organization_units hro , hr_all_organization_units_tl t , pa_conversion_types_v pct , pa_conversion_types_v pct1 WHERE pc.project_id = ppa.project_id and pc.task_id = pt.task_id and '_SEC:ppa.org_id' is not null and pc.acct_rate_type = pct.conversion_type(+) and pc.project_rate_type = pct1.conversion_type(+) and pc.organization_id=hro.organization_id (+) and pc.organization_id=t.organization_id(+) and t.language(+)=userenv('LANG') WITH READ ONLY

View Text - HTML Formatted

SELECT PC.CMT_LINE_ID
, 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
, CMT_CREATION_DATE
, CMT_APPROVED_DATE
, CMT_PROMISED_DATE
, CMT_NEED_BY_DATE
, PC.PROJECT_ID
, PPA.NAME
, PPA.SEGMENT1
, PC.TASK_ID
, PT.TASK_NAME
, PT.TASK_NUMBER
, PC.EXPENDITURE_TYPE
, PPA.ORG_ID
, PC.ORGANIZATION_ID
, T.NAME
, 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
, PCT.USER_CONVERSION_TYPE
, PC.ACCT_EXCHANGE_RATE
, PC.PROJECT_CURRENCY_CODE
, PC.PROJECT_RATE_DATE
, PC.PROJECT_RATE_TYPE
, PCT1.USER_CONVERSION_TYPE
, PC.PROJECT_EXCHANGE_RATE
, '_LA:TRANSACTION_SOURCE:PA_LOOKUPS:COMMITMENT TXN SOURCE:MEANING'
, '_LA:LINE_TYPE:PA_LOOKUPS:COMMITMENT LINE TYPE:MEANING'
, '_LA:CMT_APPROVED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, PC.CMT_DISTRIBUTION_ID
FROM PA_COMMITMENT_TXNS PC
, PA_PROJECTS_ALL PPA
, PA_TASKS PT
, HR_ALL_ORGANIZATION_UNITS HRO
, HR_ALL_ORGANIZATION_UNITS_TL T
, PA_CONVERSION_TYPES_V PCT
, PA_CONVERSION_TYPES_V PCT1
WHERE PC.PROJECT_ID = PPA.PROJECT_ID
AND PC.TASK_ID = PT.TASK_ID
AND '_SEC:PPA.ORG_ID' IS NOT NULL
AND PC.ACCT_RATE_TYPE = PCT.CONVERSION_TYPE(+)
AND PC.PROJECT_RATE_TYPE = PCT1.CONVERSION_TYPE(+)
AND PC.ORGANIZATION_ID=HRO.ORGANIZATION_ID (+)
AND PC.ORGANIZATION_ID=T.ORGANIZATION_ID(+)
AND T.LANGUAGE(+)=USERENV('LANG') WITH READ ONLY