VIEW: APPS.PSBFV_DEFAULT_ASSIGNMENTS

Source

View Text - Preformatted

SELECT PDR.NAME, '_LA:PDA.ASSIGNMENT_TYPE:FND_LOOKUPS:PSB_ASSIGNMENT_TYPE:MEANING', PA.NAME, PDA.ATTRIBUTE_VALUE, PE.NAME, '_LA:PDA.PAY_BASIS:FND_LOOKUPS:PSB_PAY_BASIS:MEANING', '_LA:PE.ELEMENT_VALUE_TYPE:FND_LOOKUPS:PSB_ELEMENT_VALUE_TYPE:MEANING', PDA.ELEMENT_VALUE, PDA.CURRENCY_CODE, PEO.GRADE_STEP, PDA.DEFAULT_ASSIGNMENT_ID, PDA.DEFAULT_RULE_ID, PDA.ATTRIBUTE_ID, PDA.ATTRIBUTE_VALUE_ID, PDA.PAY_ELEMENT_ID, PDA.PAY_ELEMENT_OPTION_ID, PDA.LAST_UPDATE_DATE, PDA.LAST_UPDATED_BY, PDA.CREATED_BY, PDA.CREATION_DATE FROM PSB_DEFAULT_ASSIGNMENTS PDA, PSB_DEFAULTS PDR, PSB_ATTRIBUTES PA, PSB_PAY_ELEMENTS PE, PSB_PAY_ELEMENT_OPTIONS PEO WHERE PDA.DEFAULT_RULE_ID = PDR.DEFAULT_RULE_ID AND PDA.ASSIGNMENT_TYPE = 'ATTRIBUTE' AND PDA.ATTRIBUTE_ID = PA.ATTRIBUTE_ID AND PDA.PAY_ELEMENT_ID = PE.PAY_ELEMENT_ID(+) AND PDA.PAY_ELEMENT_OPTION_ID = PEO.PAY_ELEMENT_OPTION_ID(+) UNION SELECT PDR.NAME, '_LA:PDA.ASSIGNMENT_TYPE:FND_LOOKUPS:PSB_ASSIGNMENT_TYPE:MEANING', PA.NAME, PDA.ATTRIBUTE_VALUE, PE.NAME, '_LA:PDA.PAY_BASIS:FND_LOOKUPS:PSB_PAY_BASIS:MEANING', '_LA:PE.ELEMENT_VALUE_TYPE:FND_LOOKUPS:PSB_ELEMENT_VALUE_TYPE:MEANING', PDA.ELEMENT_VALUE, PDA.CURRENCY_CODE, PEO.GRADE_STEP, PDA.DEFAULT_ASSIGNMENT_ID, PDA.DEFAULT_RULE_ID, PDA.ATTRIBUTE_ID, PDA.ATTRIBUTE_VALUE_ID, PDA.PAY_ELEMENT_ID, PDA.PAY_ELEMENT_OPTION_ID, PDA.LAST_UPDATE_DATE, PDA.LAST_UPDATED_BY, PDA.CREATED_BY, PDA.CREATION_DATE FROM PSB_DEFAULT_ASSIGNMENTS PDA, PSB_DEFAULTS PDR, PSB_ATTRIBUTES PA, PSB_PAY_ELEMENTS PE, PSB_PAY_ELEMENT_OPTIONS PEO WHERE PDA.DEFAULT_RULE_ID = PDR.DEFAULT_RULE_ID AND PDA.ASSIGNMENT_TYPE = 'ELEMENT' AND PDA.PAY_ELEMENT_ID = PE.PAY_ELEMENT_ID AND PDA.ATTRIBUTE_ID = PA.ATTRIBUTE_ID(+) AND PDA.PAY_ELEMENT_OPTION_ID = PEO.PAY_ELEMENT_OPTION_ID(+) with read only

View Text - HTML Formatted

SELECT PDR.NAME
, '_LA:PDA.ASSIGNMENT_TYPE:FND_LOOKUPS:PSB_ASSIGNMENT_TYPE:MEANING'
, PA.NAME
, PDA.ATTRIBUTE_VALUE
, PE.NAME
, '_LA:PDA.PAY_BASIS:FND_LOOKUPS:PSB_PAY_BASIS:MEANING'
, '_LA:PE.ELEMENT_VALUE_TYPE:FND_LOOKUPS:PSB_ELEMENT_VALUE_TYPE:MEANING'
, PDA.ELEMENT_VALUE
, PDA.CURRENCY_CODE
, PEO.GRADE_STEP
, PDA.DEFAULT_ASSIGNMENT_ID
, PDA.DEFAULT_RULE_ID
, PDA.ATTRIBUTE_ID
, PDA.ATTRIBUTE_VALUE_ID
, PDA.PAY_ELEMENT_ID
, PDA.PAY_ELEMENT_OPTION_ID
, PDA.LAST_UPDATE_DATE
, PDA.LAST_UPDATED_BY
, PDA.CREATED_BY
, PDA.CREATION_DATE
FROM PSB_DEFAULT_ASSIGNMENTS PDA
, PSB_DEFAULTS PDR
, PSB_ATTRIBUTES PA
, PSB_PAY_ELEMENTS PE
, PSB_PAY_ELEMENT_OPTIONS PEO
WHERE PDA.DEFAULT_RULE_ID = PDR.DEFAULT_RULE_ID
AND PDA.ASSIGNMENT_TYPE = 'ATTRIBUTE'
AND PDA.ATTRIBUTE_ID = PA.ATTRIBUTE_ID
AND PDA.PAY_ELEMENT_ID = PE.PAY_ELEMENT_ID(+)
AND PDA.PAY_ELEMENT_OPTION_ID = PEO.PAY_ELEMENT_OPTION_ID(+) UNION SELECT PDR.NAME
, '_LA:PDA.ASSIGNMENT_TYPE:FND_LOOKUPS:PSB_ASSIGNMENT_TYPE:MEANING'
, PA.NAME
, PDA.ATTRIBUTE_VALUE
, PE.NAME
, '_LA:PDA.PAY_BASIS:FND_LOOKUPS:PSB_PAY_BASIS:MEANING'
, '_LA:PE.ELEMENT_VALUE_TYPE:FND_LOOKUPS:PSB_ELEMENT_VALUE_TYPE:MEANING'
, PDA.ELEMENT_VALUE
, PDA.CURRENCY_CODE
, PEO.GRADE_STEP
, PDA.DEFAULT_ASSIGNMENT_ID
, PDA.DEFAULT_RULE_ID
, PDA.ATTRIBUTE_ID
, PDA.ATTRIBUTE_VALUE_ID
, PDA.PAY_ELEMENT_ID
, PDA.PAY_ELEMENT_OPTION_ID
, PDA.LAST_UPDATE_DATE
, PDA.LAST_UPDATED_BY
, PDA.CREATED_BY
, PDA.CREATION_DATE
FROM PSB_DEFAULT_ASSIGNMENTS PDA
, PSB_DEFAULTS PDR
, PSB_ATTRIBUTES PA
, PSB_PAY_ELEMENTS PE
, PSB_PAY_ELEMENT_OPTIONS PEO
WHERE PDA.DEFAULT_RULE_ID = PDR.DEFAULT_RULE_ID
AND PDA.ASSIGNMENT_TYPE = 'ELEMENT'
AND PDA.PAY_ELEMENT_ID = PE.PAY_ELEMENT_ID
AND PDA.ATTRIBUTE_ID = PA.ATTRIBUTE_ID(+)
AND PDA.PAY_ELEMENT_OPTION_ID = PEO.PAY_ELEMENT_OPTION_ID(+) WITH READ ONLY