eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CZ_CONFIG_DETAILS_V

Source

View Text - Preformatted


SELECT CZ_CONFIG_ITEMS.config_hdr_id, CZ_CONFIG_ITEMS.config_rev_nbr, CZ_CONFIG_ITEMS.config_item_id, CZ_CONFIG_ITEMS.parent_config_item_id, CZ_UTILS.CONV_NUM(DECODE(CZ_CONFIG_ITEMS.sequence_nbr, 0, NULL, CZ_CONFIG_ITEMS.sequence_nbr)) AS SEQUENCE_NBR, CZ_CONFIG_ITEMS.inventory_item_id, CZ_CONFIG_ITEMS.organization_id, CZ_CONFIG_ITEMS.node_identifier AS component_code, CZ_CONFIG_ITEMS.component_sequence_id, CZ_CONFIG_ITEMS.ITEM_NUM_VAL AS quantity, CZ_CONFIG_ITEMS.uom_code, NVL(CZ_CONFIG_ITEMS.QUOTEABLE_FLAG,'0') AS QUOTEABLE_FLAG, CZ_CONFIG_ITEMS.BOM_ITEM_TYPE, CZ_CONFIG_ITEMS.PS_NODE_ID, CZ_CONFIG_ITEMS.USER_STR01, CZ_CONFIG_ITEMS.USER_STR02, CZ_CONFIG_ITEMS.USER_STR03, CZ_CONFIG_ITEMS.USER_STR04, CZ_CONFIG_ITEMS.USER_NUM01, CZ_CONFIG_ITEMS.USER_NUM02, CZ_CONFIG_ITEMS.USER_NUM03, CZ_CONFIG_ITEMS.USER_NUM04, CZ_CONFIG_ITEMS.BOM_SORT_ORDER, CZ_CONFIG_ITEMS.INSTANCE_CONFIG_ITEM_ID AS MODEL_CONFIG_ITEM_ID, CZ_CONFIG_ITEMS.ATO_CONFIG_ITEM_ID, CZ_CONFIG_ITEMS.NAME, CZ_CONFIG_ITEMS.INSTANCE_HDR_ID, CZ_CONFIG_ITEMS.INSTANCE_REV_NBR, CZ_CONFIG_ITEMS.LINE_TYPE, CZ_CONFIG_ITEMS.COMPONENT_INSTANCE_TYPE, CZ_CONFIG_ITEMS.TARGET_HDR_ID, CZ_CONFIG_ITEMS.TARGET_REV_NBR, CZ_CONFIG_ITEMS.CONFIG_DELTA, CZ_CONFIG_ITEMS.LOCATION_ID, CZ_CONFIG_ITEMS.LOCATION_TYPE_CODE, CZ_CONFIG_ITEMS.IB_TRACKABLE, CZ_CONFIG_ITEMS.EXT_ACTIVATED_FLAG, CZ_CONFIG_HDRS.MODEL_INSTANTIATION_TYPE, CZ_CONFIG_ITEMS.DISCONTINUED_FLAG, CZ_CONFIG_ITEMS.ITEM_SRC_APPL_ID, CZ_CONFIG_ITEMS.TANGIBLE_ITEM_FLAG, CZ_CONFIG_ITEMS.RETURNED_FLAG FROM CZ_CONFIG_HDRS, CZ_CONFIG_ITEMS WHERE CZ_CONFIG_ITEMS.deleted_flag = '0' AND CZ_CONFIG_HDRS.deleted_flag = '0' AND CZ_CONFIG_ITEMS.inventory_item_id IS NOT NULL AND CZ_CONFIG_ITEMS.organization_id IS NOT NULL AND CZ_CONFIG_ITEMS.item_num_val IS NOT NULL AND NVL(CZ_CONFIG_ITEMS.item_num_val, -1) > 0 AND (CZ_CONFIG_HDRS.config_delta_spec <= CZ_CONFIG_ITEMS.config_delta OR CZ_CONFIG_ITEMS.ext_activated_flag = '1') AND CZ_CONFIG_HDRS.config_hdr_id = CZ_CONFIG_ITEMS.config_hdr_id AND CZ_CONFIG_HDRS.config_rev_nbr = CZ_CONFIG_ITEMS.config_rev_nbr

View Text - HTML Formatted

SELECT CZ_CONFIG_ITEMS.CONFIG_HDR_ID
, CZ_CONFIG_ITEMS.CONFIG_REV_NBR
, CZ_CONFIG_ITEMS.CONFIG_ITEM_ID
, CZ_CONFIG_ITEMS.PARENT_CONFIG_ITEM_ID
, CZ_UTILS.CONV_NUM(DECODE(CZ_CONFIG_ITEMS.SEQUENCE_NBR
, 0
, NULL
, CZ_CONFIG_ITEMS.SEQUENCE_NBR)) AS SEQUENCE_NBR
, CZ_CONFIG_ITEMS.INVENTORY_ITEM_ID
, CZ_CONFIG_ITEMS.ORGANIZATION_ID
, CZ_CONFIG_ITEMS.NODE_IDENTIFIER AS COMPONENT_CODE
, CZ_CONFIG_ITEMS.COMPONENT_SEQUENCE_ID
, CZ_CONFIG_ITEMS.ITEM_NUM_VAL AS QUANTITY
, CZ_CONFIG_ITEMS.UOM_CODE
, NVL(CZ_CONFIG_ITEMS.QUOTEABLE_FLAG
, '0') AS QUOTEABLE_FLAG
, CZ_CONFIG_ITEMS.BOM_ITEM_TYPE
, CZ_CONFIG_ITEMS.PS_NODE_ID
, CZ_CONFIG_ITEMS.USER_STR01
, CZ_CONFIG_ITEMS.USER_STR02
, CZ_CONFIG_ITEMS.USER_STR03
, CZ_CONFIG_ITEMS.USER_STR04
, CZ_CONFIG_ITEMS.USER_NUM01
, CZ_CONFIG_ITEMS.USER_NUM02
, CZ_CONFIG_ITEMS.USER_NUM03
, CZ_CONFIG_ITEMS.USER_NUM04
, CZ_CONFIG_ITEMS.BOM_SORT_ORDER
, CZ_CONFIG_ITEMS.INSTANCE_CONFIG_ITEM_ID AS MODEL_CONFIG_ITEM_ID
, CZ_CONFIG_ITEMS.ATO_CONFIG_ITEM_ID
, CZ_CONFIG_ITEMS.NAME
, CZ_CONFIG_ITEMS.INSTANCE_HDR_ID
, CZ_CONFIG_ITEMS.INSTANCE_REV_NBR
, CZ_CONFIG_ITEMS.LINE_TYPE
, CZ_CONFIG_ITEMS.COMPONENT_INSTANCE_TYPE
, CZ_CONFIG_ITEMS.TARGET_HDR_ID
, CZ_CONFIG_ITEMS.TARGET_REV_NBR
, CZ_CONFIG_ITEMS.CONFIG_DELTA
, CZ_CONFIG_ITEMS.LOCATION_ID
, CZ_CONFIG_ITEMS.LOCATION_TYPE_CODE
, CZ_CONFIG_ITEMS.IB_TRACKABLE
, CZ_CONFIG_ITEMS.EXT_ACTIVATED_FLAG
, CZ_CONFIG_HDRS.MODEL_INSTANTIATION_TYPE
, CZ_CONFIG_ITEMS.DISCONTINUED_FLAG
, CZ_CONFIG_ITEMS.ITEM_SRC_APPL_ID
, CZ_CONFIG_ITEMS.TANGIBLE_ITEM_FLAG
, CZ_CONFIG_ITEMS.RETURNED_FLAG
FROM CZ_CONFIG_HDRS
, CZ_CONFIG_ITEMS
WHERE CZ_CONFIG_ITEMS.DELETED_FLAG = '0'
AND CZ_CONFIG_HDRS.DELETED_FLAG = '0'
AND CZ_CONFIG_ITEMS.INVENTORY_ITEM_ID IS NOT NULL
AND CZ_CONFIG_ITEMS.ORGANIZATION_ID IS NOT NULL
AND CZ_CONFIG_ITEMS.ITEM_NUM_VAL IS NOT NULL
AND NVL(CZ_CONFIG_ITEMS.ITEM_NUM_VAL
, -1) > 0
AND (CZ_CONFIG_HDRS.CONFIG_DELTA_SPEC <= CZ_CONFIG_ITEMS.CONFIG_DELTA OR CZ_CONFIG_ITEMS.EXT_ACTIVATED_FLAG = '1')
AND CZ_CONFIG_HDRS.CONFIG_HDR_ID = CZ_CONFIG_ITEMS.CONFIG_HDR_ID
AND CZ_CONFIG_HDRS.CONFIG_REV_NBR = CZ_CONFIG_ITEMS.CONFIG_REV_NBR