VIEW: APPS.CZ_CONFIG_ITEMS_V

Source

View Text - Preformatted

SELECT A.CONFIG_HDR_ID, A.CONFIG_REV_NBR, A.CONFIG_ITEM_ID, A.PS_NODE_ID, A.VALUE_TYPE_CODE, A.SEQUENCE_NBR, nvl(A.ITEM_VAL, to_char(A.ITEM_NUM_VAL)) AS ITEM_VAL, A.INSTANCE_NBR, A.PARENT_CONFIG_ITEM_ID, A.NODE_IDENTIFIER, A.INVENTORY_ITEM_ID, A.ORGANIZATION_ID, A.COMPONENT_SEQUENCE_ID, A.UOM_CODE, A.USER_STR01, A.USER_STR02, A.USER_STR03, A.USER_STR04, A.USER_NUM01, A.USER_NUM02, A.USER_NUM03, A.USER_NUM04, A.BOM_ITEM_TYPE, A.QUOTEABLE_FLAG, A.BOM_SORT_ORDER, A.TARGET_CONFIG_ITEM_ID, A.INSTANCE_CONFIG_ITEM_ID, A.NAME, A.ATO_CONFIG_ITEM_ID, A.INSTANCE_HDR_ID, A.INSTANCE_REV_NBR, A.TARGET_HDR_ID, A.TARGET_REV_NBR, A.CONFIG_DELTA, A.LOCATION_ID, A.LOCATION_TYPE_CODE, A.COMPONENT_INSTANCE_TYPE, A.IB_TRACKABLE, A.EXT_ACTIVATED_FLAG, A.LINE_TYPE, B.MODEL_INSTANTIATION_TYPE, A. DISCONTINUED_FLAG, A.ITEM_NUM_VAL, A.ORIG_SYS_REF, A.ITEM_SRC_APPL_ID, A.PS_NODE_NAME, A.TANGIBLE_ITEM_FLAG, A.RETURNED_FLAG FROM CZ_CONFIG_ITEMS A, CZ_CONFIG_HDRS B WHERE A.DELETED_FLAG = '0' AND A.CONFIG_HDR_ID = B.CONFIG_HDR_ID AND A.CONFIG_REV_NBR = B.CONFIG_REV_NBR

View Text - HTML Formatted

SELECT A.CONFIG_HDR_ID
, A.CONFIG_REV_NBR
, A.CONFIG_ITEM_ID
, A.PS_NODE_ID
, A.VALUE_TYPE_CODE
, A.SEQUENCE_NBR
, NVL(A.ITEM_VAL
, TO_CHAR(A.ITEM_NUM_VAL)) AS ITEM_VAL
, A.INSTANCE_NBR
, A.PARENT_CONFIG_ITEM_ID
, A.NODE_IDENTIFIER
, A.INVENTORY_ITEM_ID
, A.ORGANIZATION_ID
, A.COMPONENT_SEQUENCE_ID
, A.UOM_CODE
, A.USER_STR01
, A.USER_STR02
, A.USER_STR03
, A.USER_STR04
, A.USER_NUM01
, A.USER_NUM02
, A.USER_NUM03
, A.USER_NUM04
, A.BOM_ITEM_TYPE
, A.QUOTEABLE_FLAG
, A.BOM_SORT_ORDER
, A.TARGET_CONFIG_ITEM_ID
, A.INSTANCE_CONFIG_ITEM_ID
, A.NAME
, A.ATO_CONFIG_ITEM_ID
, A.INSTANCE_HDR_ID
, A.INSTANCE_REV_NBR
, A.TARGET_HDR_ID
, A.TARGET_REV_NBR
, A.CONFIG_DELTA
, A.LOCATION_ID
, A.LOCATION_TYPE_CODE
, A.COMPONENT_INSTANCE_TYPE
, A.IB_TRACKABLE
, A.EXT_ACTIVATED_FLAG
, A.LINE_TYPE
, B.MODEL_INSTANTIATION_TYPE
, A. DISCONTINUED_FLAG
, A.ITEM_NUM_VAL
, A.ORIG_SYS_REF
, A.ITEM_SRC_APPL_ID
, A.PS_NODE_NAME
, A.TANGIBLE_ITEM_FLAG
, A.RETURNED_FLAG
FROM CZ_CONFIG_ITEMS A
, CZ_CONFIG_HDRS B
WHERE A.DELETED_FLAG = '0'
AND A.CONFIG_HDR_ID = B.CONFIG_HDR_ID
AND A.CONFIG_REV_NBR = B.CONFIG_REV_NBR