VIEW: APPS.PAFV_EXPENDITURES

Source

View Text - Preformatted

SELECT pea.expenditure_id ,pea.description ,pea.control_total_amount ,pea.expenditure_ending_date ,pea.expenditure_group ,pega.description ,pea.incurred_by_person_id ,papf.full_name ,pea.incurred_by_organization_id ,tl1.name ,pea.org_id ,tl2.name ,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.user_batch_name ,pea.LAST_UPDATE_DATE ,pea.LAST_UPDATED_BY ,pea.CREATION_DATE ,pea.CREATED_BY ,pea.TRANSFER_STATUS_CODE ,'_LA:expenditure_status_code:PA_LOOKUPS:EXPENDITURE STATUS:MEANING' ,'_LA:expenditure_class_code:PA_LOOKUPS:EXPENDITURE CLASS CODE:MEANING' ,'_DF:PA:PA_EXPENDITURES_DESC_FLEX:pea' FROM pa_expenditures_all pea, hr_all_organization_units_tl tl1, hr_all_organization_units_tl tl2, per_all_people_f papf, pa_expenditure_groups_all pega WHERE pea.expenditure_group = pega.expenditure_group(+) and ( nvl(pea.org_id, -99) = nvl(pega.org_id, -99) or pega.expenditure_group is null) and pea.incurred_by_organization_id = tl1.organization_id(+) and pea.org_id=tl2.organization_id(+) and tl1.language (+) = userenv('LANG') and tl2.language (+) = userenv('LANG') and pea.incurred_by_person_id = papf.person_id(+) and trunc(sysdate) between papf.effective_start_date (+) and papf.effective_end_date (+) and '_SEC:pea.org_id' is not null WITH READ ONLY

View Text - HTML Formatted

SELECT PEA.EXPENDITURE_ID
, PEA.DESCRIPTION
, PEA.CONTROL_TOTAL_AMOUNT
, PEA.EXPENDITURE_ENDING_DATE
, PEA.EXPENDITURE_GROUP
, PEGA.DESCRIPTION
, PEA.INCURRED_BY_PERSON_ID
, PAPF.FULL_NAME
, PEA.INCURRED_BY_ORGANIZATION_ID
, TL1.NAME
, PEA.ORG_ID
, TL2.NAME
, 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.USER_BATCH_NAME
, PEA.LAST_UPDATE_DATE
, PEA.LAST_UPDATED_BY
, PEA.CREATION_DATE
, PEA.CREATED_BY
, PEA.TRANSFER_STATUS_CODE
, '_LA:EXPENDITURE_STATUS_CODE:PA_LOOKUPS:EXPENDITURE STATUS:MEANING'
, '_LA:EXPENDITURE_CLASS_CODE:PA_LOOKUPS:EXPENDITURE CLASS CODE:MEANING'
, '_DF:PA:PA_EXPENDITURES_DESC_FLEX:PEA'
FROM PA_EXPENDITURES_ALL PEA
, HR_ALL_ORGANIZATION_UNITS_TL TL1
, HR_ALL_ORGANIZATION_UNITS_TL TL2
, PER_ALL_PEOPLE_F PAPF
, PA_EXPENDITURE_GROUPS_ALL PEGA
WHERE PEA.EXPENDITURE_GROUP = PEGA.EXPENDITURE_GROUP(+)
AND ( NVL(PEA.ORG_ID
, -99) = NVL(PEGA.ORG_ID
, -99) OR PEGA.EXPENDITURE_GROUP IS NULL)
AND PEA.INCURRED_BY_ORGANIZATION_ID = TL1.ORGANIZATION_ID(+)
AND PEA.ORG_ID=TL2.ORGANIZATION_ID(+)
AND TL1.LANGUAGE (+) = USERENV('LANG')
AND TL2.LANGUAGE (+) = USERENV('LANG')
AND PEA.INCURRED_BY_PERSON_ID = PAPF.PERSON_ID(+)
AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE (+)
AND PAPF.EFFECTIVE_END_DATE (+)
AND '_SEC:PEA.ORG_ID' IS NOT NULL WITH READ ONLY