View: POA_EDW_CUSTOM_MEASURE_FCV

Product:	PO - Purchasing
Description:
Implementation/DBA Data:	APPS.POA_EDW_CUSTOM_MEASURE_FCV

View Text

SELECT INC.SEQ_ID SEQ_ID
, 1 VIEW_ID
, PMS.EVALUATION_SCORE_ID || '-' || TO_CHAR(GPM.ACCOUNTING_DATE
, 'DD-MM-YYYY') || '-' || ELI.INSTANCE_CODE CSTM_MSR_PK
, ELI.INSTANCE_CODE INSTANCE_FK
, PME.CUSTOM_MEASURE_CODE || '-' || 'CUSTOM MEASURE' || '-' || 'PO' CUSTOM_MEASURE_FK
, PMS.CRITERIA_CODE || '-' || 'SATISFACTION CRITERIA' || '-' || 'PO' CRITERIA_CODE_FK
, EDW_TIME_PKG.CAL_DAY_FK(GPM.ACCOUNTING_DATE
, FSP.SET_OF_BOOKS_ID
, ELI.INSTANCE_CODE) EVAL_DATE_FK
, DECODE(PME.SUPPLIER_SITE_ID
, NULL
, EDW_TRD_PARTNER_PKG.SUPPLIER_FK (PME.SUPPLIER_ID
, ELI.INSTANCE_CODE)
, EDW_TRD_PARTNER_PKG.SUPPLIER_SITE_FK (PME.SUPPLIER_SITE_ID
, PME.ORG_ID
, ELI.INSTANCE_CODE)) SUPPLIER_SITE_FK
, EDW_ORGANIZATION_PKG.OPERATING_UNIT_FK (PME.OPER_UNIT_ID
, ELI.INSTANCE_CODE) OPERATING_UNIT_FK
, DECODE(PME.ITEM_ID
, NULL
, DECODE(PME.CATEGORY_ID
, NULL
, 'NA_EDW'
, EDW_ITEMS_PKG.CATEGORY_FK (2
, 2
, PME.CATEGORY_ID
, ELI.INSTANCE_CODE))
, EDW_ITEMS_PKG.ITEM_ORG_FK(PME.ITEM_ID
, DECODE(PME.ITEM_ID
, NULL
, PME.ORG_ID
, FSP.INVENTORY_ORGANIZATION_ID)
, NULL
, TO_NUMBER(NULL)
, ELI.INSTANCE_CODE)) ITEM_FK
, PMS.SCORE SCORE
, PMS.WEIGHT WEIGHT
, (PMS.SCORE-PMS.MIN_SCORE)/(PMS.MAX_SCORE-PMS.MIN_SCORE)*PMS.WEIGHT WEIGHTED_SCORE
, PMS.MIN_SCORE MIN_SCORE
, PMS.MAX_SCORE MAX_SCORE
, GREATEST(PMS.LAST_UPDATE_DATE
, FSP.LAST_UPDATE_DATE
, PME.LAST_UPDATE_DATE
, GPM.LAST_UPDATE_DATE) LAST_UPDATE_DATE
, FU.USER_NAME USER_NAME
, PME.COMMENTS EVAL_COMMENTS
, PMS.COMMENTS SCORE_COMMENTS
, NULL OPERATION_CODE
, NULL DUNS_FK
, NULL UNSPSC_FK
, NULL SIC_CODE_FK
, NULL USER_ATTRIBUTE1
, NULL USER_ATTRIBUTE2
, NULL USER_ATTRIBUTE3
, NULL USER_ATTRIBUTE4
, NULL USER_ATTRIBUTE5
, NULL USER_ATTRIBUTE6
, NULL USER_ATTRIBUTE7
, NULL USER_ATTRIBUTE8
, NULL USER_ATTRIBUTE9
, NULL USER_ATTRIBUTE10
, NULL USER_ATTRIBUTE11
, NULL USER_ATTRIBUTE12
, NULL USER_ATTRIBUTE13
, NULL USER_ATTRIBUTE14
, NULL USER_ATTRIBUTE15
, NULL USER_FK1
, NULL USER_FK2
, NULL USER_FK3
, NULL USER_FK4
, NULL USER_FK5
, TO_NUMBER(NULL) USER_MEASURE1
, TO_NUMBER(NULL) USER_MEASURE2
, TO_NUMBER(NULL) USER_MEASURE3
, TO_NUMBER(NULL) USER_MEASURE4
, TO_NUMBER(NULL) USER_MEASURE5
, PME.EVALUATION_ID EVALUATION_ID FROM POA_EDW_CSTM_MSR_INC INC
, POA_CM_EVAL_SCORES PMS
, POA_CM_EVALUATION PME
, GL_DATE_PERIOD_MAP GPM
, FND_USER FU
, GL_SETS_OF_BOOKS GSOB
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
, EDW_LOCAL_INSTANCE ELI
WHERE INC.PRIMARY_KEY = PMS.EVALUATION_SCORE_ID
AND PMS.EVALUATION_ID = PME.EVALUATION_ID AND NVL(FSP.ORG_ID
, -999) = NVL(PME.ORG_ID
, -999)
AND GSOB.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID AND GPM.PERIOD_SET_NAME = GSOB.PERIOD_SET_NAME AND GPM.PERIOD_TYPE = PME.PERIOD_TYPE AND GPM.PERIOD_NAME = PME.PERIOD_NAME AND FU.USER_ID (+)= PME.EVALUATED_BY

Columns