VIEW: APPS.MTH_SRC_RESOURCE_COST_V

Source

View Text - Preformatted

SELECT RESOURCE_FK, FROM_DATE, TO_DATE, COST_ELEMENT, COST, SYSTEM_FK, USER_ATTR1, USER_ATTR2, USER_ATTR3, USER_ATTR4, USER_ATTR5, RESOURCE_ID, DEPARTMENT_ID, SOURCE_ORG_CODE, LAST_UPDATE_DATE FROM (SELECT CAST(NULL AS VARCHAR2(150)) RESOURCE_FK, CRC.LAST_UPDATE_DATE FROM_DATE, CAST(NULL AS DATE) To_Date, CAST(NULL AS VARCHAR2(150)) COST_ELEMENT, CRC.RESOURCE_RATE COST, fnd_profile.value('MTH_EBS_GLOBAL_NAME') SYSTEM_FK, CAST(NULL AS VARCHAR2(150)) USER_ATTR1, CAST(NULL AS VARCHAR2(150)) USER_ATTR2, CAST(NULL AS VARCHAR2(150)) USER_ATTR3, CAST(NULL AS VARCHAR2(150)) USER_ATTR4, CAST(NULL AS VARCHAR2(150)) USER_ATTR5, CRC.RESOURCE_ID RESOURCE_ID, BDR.DEPARTMENT_ID DEPARTMENT_ID, MP.ORGANIZATION_CODE SOURCE_ORG_CODE, CRC.LAST_UPDATE_DATE LAST_UPDATE_DATE FROM CST_RESOURCE_COSTS CRC, MTL_PARAMETERS MP, BOM_DEPARTMENT_RESOURCES BDR WHERE CRC.ORGANIZATION_ID = MP.ORGANIZATION_ID AND NVL(MP.AVG_RATES_COST_TYPE_ID,1) = CRC.COST_TYPE_ID AND MP.GENERAL_LEDGER_UPDATE_CODE IN (1,2) AND CRC.RESOURCE_ID = BDR.RESOURCE_ID)

View Text - HTML Formatted

SELECT RESOURCE_FK
, FROM_DATE
, TO_DATE
, COST_ELEMENT
, COST
, SYSTEM_FK
, USER_ATTR1
, USER_ATTR2
, USER_ATTR3
, USER_ATTR4
, USER_ATTR5
, RESOURCE_ID
, DEPARTMENT_ID
, SOURCE_ORG_CODE
, LAST_UPDATE_DATE
FROM (SELECT CAST(NULL AS VARCHAR2(150)) RESOURCE_FK
, CRC.LAST_UPDATE_DATE FROM_DATE
, CAST(NULL AS DATE) TO_DATE
, CAST(NULL AS VARCHAR2(150)) COST_ELEMENT
, CRC.RESOURCE_RATE COST
, FND_PROFILE.VALUE('MTH_EBS_GLOBAL_NAME') SYSTEM_FK
, CAST(NULL AS VARCHAR2(150)) USER_ATTR1
, CAST(NULL AS VARCHAR2(150)) USER_ATTR2
, CAST(NULL AS VARCHAR2(150)) USER_ATTR3
, CAST(NULL AS VARCHAR2(150)) USER_ATTR4
, CAST(NULL AS VARCHAR2(150)) USER_ATTR5
, CRC.RESOURCE_ID RESOURCE_ID
, BDR.DEPARTMENT_ID DEPARTMENT_ID
, MP.ORGANIZATION_CODE SOURCE_ORG_CODE
, CRC.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM CST_RESOURCE_COSTS CRC
, MTL_PARAMETERS MP
, BOM_DEPARTMENT_RESOURCES BDR
WHERE CRC.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND NVL(MP.AVG_RATES_COST_TYPE_ID
, 1) = CRC.COST_TYPE_ID
AND MP.GENERAL_LEDGER_UPDATE_CODE IN (1
, 2)
AND CRC.RESOURCE_ID = BDR.RESOURCE_ID)