VIEW: APPS.PAY_FUNCTIONAL_USAGES_V

Source

View Text - Preformatted

SELECT pfu.rowid row_id, pfu.usage_id, pfu.area_id, pfa.short_name, pfa.description, pfu.legislation_code, DECODE(pfu.legislation_code,'-1','',ft.territory_short_name) "LEGISLATION_NAME", pfu.business_group_id, DECODE(pfu.business_group_id,-1,'',bg.name) "BUSINESS_GROUP_NAME", pfu.payroll_id, DECODE(pfu.payroll_id,-1,'',papf.payroll_name) "PAYROLL_NAME", pfu.last_update_date,pfu.last_updated_by, pfu.last_update_login, pfu.created_by,pfu.creation_date FROM pay_all_payrolls papf, per_business_groups bg, fnd_territories_vl ft, pay_functional_areas pfa, pay_functional_usages pfu WHERE papf.payroll_id (+)= pfu.payroll_id AND bg.business_group_id (+)= pfu.business_group_id AND ft.territory_code (+)= pfu.legislation_code AND pfa.area_id = pfu.area_id

View Text - HTML Formatted

SELECT PFU.ROWID ROW_ID
, PFU.USAGE_ID
, PFU.AREA_ID
, PFA.SHORT_NAME
, PFA.DESCRIPTION
, PFU.LEGISLATION_CODE
, DECODE(PFU.LEGISLATION_CODE
, '-1'
, ''
, FT.TERRITORY_SHORT_NAME) "LEGISLATION_NAME"
, PFU.BUSINESS_GROUP_ID
, DECODE(PFU.BUSINESS_GROUP_ID
, -1
, ''
, BG.NAME) "BUSINESS_GROUP_NAME"
, PFU.PAYROLL_ID
, DECODE(PFU.PAYROLL_ID
, -1
, ''
, PAPF.PAYROLL_NAME) "PAYROLL_NAME"
, PFU.LAST_UPDATE_DATE
, PFU.LAST_UPDATED_BY
, PFU.LAST_UPDATE_LOGIN
, PFU.CREATED_BY
, PFU.CREATION_DATE
FROM PAY_ALL_PAYROLLS PAPF
, PER_BUSINESS_GROUPS BG
, FND_TERRITORIES_VL FT
, PAY_FUNCTIONAL_AREAS PFA
, PAY_FUNCTIONAL_USAGES PFU
WHERE PAPF.PAYROLL_ID (+)= PFU.PAYROLL_ID
AND BG.BUSINESS_GROUP_ID (+)= PFU.BUSINESS_GROUP_ID
AND FT.TERRITORY_CODE (+)= PFU.LEGISLATION_CODE
AND PFA.AREA_ID = PFU.AREA_ID