VIEW: APPS.CST_ROLLUP_DATE_VIEW

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)