VIEW: APPS.PABV_EXPENDITURES

Source

View Text - Preformatted

SELECT pea.expenditure_id , '_LA:expenditure_status_code:PA_LOOKUPS:EXPENDITURE STATUS:MEANING' , '_LA:expenditure_class_code:PA_LOOKUPS:EXPENDITURE CLASS CODE:MEANING' , pea.description , pea.control_total_amount , pea.expenditure_ending_date , pea.expenditure_group , pea.incurred_by_person_id , pea.incurred_by_organization_id , org_id /* Operating unit */ , pea.ORIG_EXP_TXN_REFERENCE1 ,pea.ORIG_USER_EXP_TXN_REFERENCE ,pea.VENDOR_ID ,pea.ORIG_EXP_TXN_REFERENCE2 ,pea.ORIG_EXP_TXN_REFERENCE3 ,pea.overriding_approver_person_id ,pea.wf_status_code ,pea.transfer_status_code ,'_DF:PA:PA_EXPENDITURES_DESC_FLEX:pea' , pea.LAST_UPDATE_DATE , pea.LAST_UPDATED_BY , pea.CREATION_DATE , pea.CREATED_BY , pea.USER_BATCH_NAME FROM pa_expenditures_all pea WHERE '_SEC:pea.org_id' is not null WITH READ ONLY

View Text - HTML Formatted

SELECT PEA.EXPENDITURE_ID
, '_LA:EXPENDITURE_STATUS_CODE:PA_LOOKUPS:EXPENDITURE STATUS:MEANING'
, '_LA:EXPENDITURE_CLASS_CODE:PA_LOOKUPS:EXPENDITURE CLASS CODE:MEANING'
, PEA.DESCRIPTION
, PEA.CONTROL_TOTAL_AMOUNT
, PEA.EXPENDITURE_ENDING_DATE
, PEA.EXPENDITURE_GROUP
, PEA.INCURRED_BY_PERSON_ID
, PEA.INCURRED_BY_ORGANIZATION_ID
, ORG_ID /* OPERATING UNIT */
, PEA.ORIG_EXP_TXN_REFERENCE1
, PEA.ORIG_USER_EXP_TXN_REFERENCE
, PEA.VENDOR_ID
, PEA.ORIG_EXP_TXN_REFERENCE2
, PEA.ORIG_EXP_TXN_REFERENCE3
, PEA.OVERRIDING_APPROVER_PERSON_ID
, PEA.WF_STATUS_CODE
, PEA.TRANSFER_STATUS_CODE
, '_DF:PA:PA_EXPENDITURES_DESC_FLEX:PEA'
, PEA.LAST_UPDATE_DATE
, PEA.LAST_UPDATED_BY
, PEA.CREATION_DATE
, PEA.CREATED_BY
, PEA.USER_BATCH_NAME
FROM PA_EXPENDITURES_ALL PEA
WHERE '_SEC:PEA.ORG_ID' IS NOT NULL WITH READ ONLY