View: CST_ROLLUP_DATE_VIEW

Product:	BOM - Bills of Material
Description:	Cost rollup date : SINGLE-ORG view
Implementation/DBA Data:	APPS.CST_ROLLUP_DATE_VIEW

View Text

SELECT TO_CHAR(C.REVISION_DATE
, 'DD-MON-YY HH24:MI')
, RO.MEANING
, RANGE.MEANING
, ECN.MEANING
, C.ALTERNATE_BOM_DESIGNATOR
, C.ALTERNATE_RTG_DESIGNATOR
, ENG.MEANING
, C.INVENTORY_ITEM_ID
, S.CATEGORY_SET_NAME
, C.CATEGORY
, C.RANGE_LOW
, C.RANGE_HIGH
, C.COST_TYPE_ID
, C.ORGANIZATION_ID
, C.ROLLUP_ID
, C.ROLLUP_DATE
FROM CST_COST_TYPE_HISTORY C
, MFG_LOOKUPS RO
, MFG_LOOKUPS RANGE
, MFG_LOOKUPS ECN
, MFG_LOOKUPS ENG
, MTL_CATEGORY_SETS S
WHERE C.ROLLUP_OPTION = RO.LOOKUP_CODE
AND RO.LOOKUP_TYPE = 'CST_ROLLUP_TYPE'
AND C.RANGE = RANGE.LOOKUP_CODE
AND RANGE.LOOKUP_TYPE = 'CST_ITEM_RANGE'
AND C.ENGINEERING_FLAG = ENG.LOOKUP_CODE
AND ENG.LOOKUP_TYPE = 'SYS_YES_NO'
AND C.UNIMPLEMENTED_ECN_FLAG = ECN.LOOKUP_CODE
AND ECN.LOOKUP_TYPE = 'SYS_YES_NO'
AND C.CATEGORY_SET_ID = S.CATEGORY_SET_ID(+)

Columns