VIEW: APPS.VEA_LAYERS_V

Source

View Text - Preformatted

SELECT LA.LAYER_ID, LA.LAYER_PROVIDER_CODE, LA.LAYER_HEADER_ID, LA.ACTIVE_FLAG, LA.NEW_PROGRAM_UNIT_ID, LA.PROGRAM_UNIT_LP_CODE, LA.SEQUENCE_NUMBER, LA.DESCRIPTION, LA.TPS_PARAMETER1_ID, LA.TPS_PARAMETER1_VALUE, LA.TPS_PARAMETER2_ID, LA.TPS_PARAMETER2_VALUE, LA.TPS_PARAMETER3_ID, LA.TPS_PARAMETER3_VALUE, LA.TPS_PARAMETER4_ID, LA.TPS_PARAMETER4_VALUE, LA.TPS_PARAMETER5_ID, LA.TPS_PARAMETER5_VALUE, LA.TPS_PARAMETER6_ID, LA.TPS_PARAMETER6_VALUE, LA.TPS_PARAMETER7_ID, LA.TPS_PARAMETER7_VALUE, LA.TPS_PARAMETER8_ID, LA.TPS_PARAMETER8_VALUE, LA.TPS_PARAMETER9_ID, LA.TPS_PARAMETER9_VALUE, LA.TPS_PARAMETER10_ID, LA.TPS_PARAMETER10_VALUE, TLA.TP_LAYER_ID, TLA.NAME TP_LAYER_NAME, TLA.ACTIVE_FLAG TP_LAYER_ACTIVE_FLAG, TLA.DESCRIPTION TP_LAYER_DESCRIPTION, DECODE(TLA.ACTIVE_FLAG,'N','N',LA.ACTIVE_FLAG) IS_LAYER_ACTIVE, LH.TPS_PROGRAM_UNIT_LP_CODE from vea_layers LA, vea_program_units APU, vea_packages PK, vea_tp_layers TLA, vea_layer_headers LH WHERE APU.layer_provider_code = LA.program_unit_lp_code and APU.program_unit_id = LA.new_program_unit_id and PK.layer_provider_code = APU.layer_provider_code and PK.package_id = APU.package_id and TLA.layer_provider_code = PK.layer_provider_code and TLA.tp_layer_id = PK.tp_layer_id and LH.LAYER_HEADER_ID = LA.LAYER_HEADER_ID and LH.LAYER_PROVIDER_CODE = LA.LAYER_PROVIDER_CODE

View Text - HTML Formatted

SELECT LA.LAYER_ID
, LA.LAYER_PROVIDER_CODE
, LA.LAYER_HEADER_ID
, LA.ACTIVE_FLAG
, LA.NEW_PROGRAM_UNIT_ID
, LA.PROGRAM_UNIT_LP_CODE
, LA.SEQUENCE_NUMBER
, LA.DESCRIPTION
, LA.TPS_PARAMETER1_ID
, LA.TPS_PARAMETER1_VALUE
, LA.TPS_PARAMETER2_ID
, LA.TPS_PARAMETER2_VALUE
, LA.TPS_PARAMETER3_ID
, LA.TPS_PARAMETER3_VALUE
, LA.TPS_PARAMETER4_ID
, LA.TPS_PARAMETER4_VALUE
, LA.TPS_PARAMETER5_ID
, LA.TPS_PARAMETER5_VALUE
, LA.TPS_PARAMETER6_ID
, LA.TPS_PARAMETER6_VALUE
, LA.TPS_PARAMETER7_ID
, LA.TPS_PARAMETER7_VALUE
, LA.TPS_PARAMETER8_ID
, LA.TPS_PARAMETER8_VALUE
, LA.TPS_PARAMETER9_ID
, LA.TPS_PARAMETER9_VALUE
, LA.TPS_PARAMETER10_ID
, LA.TPS_PARAMETER10_VALUE
, TLA.TP_LAYER_ID
, TLA.NAME TP_LAYER_NAME
, TLA.ACTIVE_FLAG TP_LAYER_ACTIVE_FLAG
, TLA.DESCRIPTION TP_LAYER_DESCRIPTION
, DECODE(TLA.ACTIVE_FLAG
, 'N'
, 'N'
, LA.ACTIVE_FLAG) IS_LAYER_ACTIVE
, LH.TPS_PROGRAM_UNIT_LP_CODE
FROM VEA_LAYERS LA
, VEA_PROGRAM_UNITS APU
, VEA_PACKAGES PK
, VEA_TP_LAYERS TLA
, VEA_LAYER_HEADERS LH
WHERE APU.LAYER_PROVIDER_CODE = LA.PROGRAM_UNIT_LP_CODE
AND APU.PROGRAM_UNIT_ID = LA.NEW_PROGRAM_UNIT_ID
AND PK.LAYER_PROVIDER_CODE = APU.LAYER_PROVIDER_CODE
AND PK.PACKAGE_ID = APU.PACKAGE_ID
AND TLA.LAYER_PROVIDER_CODE = PK.LAYER_PROVIDER_CODE
AND TLA.TP_LAYER_ID = PK.TP_LAYER_ID
AND LH.LAYER_HEADER_ID = LA.LAYER_HEADER_ID
AND LH.LAYER_PROVIDER_CODE = LA.LAYER_PROVIDER_CODE