View: VEA_LAYERS_V

Product:	VEA - Automotive
Description:
Implementation/DBA Data:	APPS.VEA_LAYERS_V

View Text

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
FROM VEA_LAYERS LA
, VEA_PROGRAM_UNITS APU
, VEA_PACKAGES PK
, VEA_TP_LAYERS TLA
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

Columns