1. Tables and Views for SCM
  2. DOO_PC_CONDITIONS_V

DOO_PC_CONDITIONS_V

Details

  • Schema: FUSION

  • Object owner: DOO

  • Object type: VIEW

Columns

Name

ROW_ID

CONDITION_ID

CONSTRAINT_ID

MODULE_ID

ENTITY_ID

GROUP_NUMBER

CREATION_DATE

CREATED_BY

LAST_UPDATE_DATE

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

SYSTEM_FLAG

MODIFIER_FLAG

VALIDATION_APPLICATION_ID

VALIDATION_ENTITY_ID

VALIDATION_TMPLT_ID

VALIDATION_TMPLT_SHORT_NAME

RECORD_SET_ID

RECORD_SET_SHORT_NAME

SCOPE_OP

ENTITY_CODE

VEENTITY_CODE

VALIDATION_PKG

VALIDATION_PROC

ATTRIBUTE_CATEGORY

ENABLED_FLAG

Query

SQL_Statement

SELECT

r.ROWID row_id,

r.CONDITION_ID,

r.CONSTRAINT_ID,

r.MODULE_ID,

c.ENTITY_ID,

r.GROUP_NUMBER,

r.CREATION_DATE,

r.CREATED_BY,

r.LAST_UPDATE_DATE,

r.LAST_UPDATED_BY,

r.LAST_UPDATE_LOGIN,

r.SYSTEM_FLAG,

r.MODIFIER_FLAG,

c.MODULE_ID validation_application_id,

r.VALIDATION_ENTITY_ID,

r.VALIDATION_TMPLT_ID,

v.VALIDATION_TMPLT_SHORT_NAME,

r.RECORD_SET_ID,

s.RECORD_SET_SHORT_NAME,

r.SCOPE_OP,

OE.ENTITY_CODE,

OVE.ENTITY_CODE VEENTITY_CODE,

DECODE(v.VALIDATION_TYPE, 'API', v.API_PKG, 'PRTSK', 'PRTSK', 'ADXX_' || substr(DOA.ORCHESTRATION_APPLICATION_CODE,1,3) || '_PC_' || SUBSTR(TO_CHAR(OE.ENTITY_CODE), 5, 1) || SUBSTR(TO_CHAR(OVE.ENTITY_CODE), 5, 1) || '_' || s.RECORD_SET_SHORT_NAME || v.VALIDATION_TMPLT_SHORT_NAME) validation_pkg,

DECODE(v.VALIDATION_TYPE, 'API', v.API_PROC, 'Is_Valid') validation_proc,

r.ATTRIBUTE_CATEGORY,

r.ENABLED_FLAG

FROM

DOO_PC_CONDITIONS_B r,

DOO_PC_CONSTRAINTS_F c,

DOO_PC_VTMPLTS_B v,

DOO_PC_RSETS_B s,

DOO_OBJECTS_B OE,

DOO_OBJECTS_B OVE ,

DOO_ORCHESTRATION_APPLICATIONS DOA

WHERE

r.CONSTRAINT_ID = c.CONSTRAINT_ID AND r.VALIDATION_TMPLT_ID = v.VALIDATION_TMPLT_ID AND r.RECORD_SET_ID = s.RECORD_SET_ID AND OVE.ENTITY_ID = r.VALIDATION_ENTITY_ID AND OE.ENTITY_ID = c.ENTITY_ID AND DOA.ORCHESTRATION_APPLICATION_ID=c.MODULE_ID