VIEW: APPS.PSBFV_PARAMETERS

Source

View Text - Preformatted

SELECT pe.name, gl.name, de.data_extract_name, '_LA:entity_subtype:FND_LOOKUPS:PSB_PARAMETER_TYPE:meaning', pe.description, pe.currency_code, pe.parameter_autoinc_rule, pe.parameter_compound_annually, '_DF:PSB:PSB_ENTITY:pe', pe.entity_id, pe.set_of_books_id, pe.data_extract_id, pe.last_update_date, pe.last_updated_by, pe.created_by, pe.creation_date FROM psb_entity pe, gl_sets_of_books gl, psb_data_extracts de WHERE gl.set_of_books_id(+) = pe.set_of_books_id AND de.data_extract_id(+) = pe.data_extract_id AND pe.entity_type = 'PARAMETER' WITH READ ONLY

View Text - HTML Formatted

SELECT PE.NAME
, GL.NAME
, DE.DATA_EXTRACT_NAME
, '_LA:ENTITY_SUBTYPE:FND_LOOKUPS:PSB_PARAMETER_TYPE:MEANING'
, PE.DESCRIPTION
, PE.CURRENCY_CODE
, PE.PARAMETER_AUTOINC_RULE
, PE.PARAMETER_COMPOUND_ANNUALLY
, '_DF:PSB:PSB_ENTITY:PE'
, PE.ENTITY_ID
, PE.SET_OF_BOOKS_ID
, PE.DATA_EXTRACT_ID
, PE.LAST_UPDATE_DATE
, PE.LAST_UPDATED_BY
, PE.CREATED_BY
, PE.CREATION_DATE
FROM PSB_ENTITY PE
, GL_SETS_OF_BOOKS GL
, PSB_DATA_EXTRACTS DE
WHERE GL.SET_OF_BOOKS_ID(+) = PE.SET_OF_BOOKS_ID
AND DE.DATA_EXTRACT_ID(+) = PE.DATA_EXTRACT_ID
AND PE.ENTITY_TYPE = 'PARAMETER' WITH READ ONLY