VIEW: QP.QP_ATTRIBUTE_GROUPS#

Source

View Text - Preformatted

select LIST_HEADER_ID LIST_HEADER_ID, LIST_LINE_ID LIST_LINE_ID, ACTIVE_FLAG ACTIVE_FLAG, LIST_TYPE_CODE LIST_TYPE_CODE, START_DATE_ACTIVE_Q START_DATE_ACTIVE_Q, END_DATE_ACTIVE_Q END_DATE_ACTIVE_Q, PATTERN_ID PATTERN_ID, CURRENCY_CODE CURRENCY_CODE, ASK_FOR_FLAG ASK_FOR_FLAG, LIMIT_EXISTS LIMIT_EXISTS, SOURCE_SYSTEM_CODE SOURCE_SYSTEM_CODE, EFFECTIVE_PRECEDENCE EFFECTIVE_PRECEDENCE, GROUPING_NO GROUPING_NO, PRICING_PHASE_ID PRICING_PHASE_ID, MODIFIER_LEVEL_CODE MODIFIER_LEVEL_CODE, HASH_KEY HASH_KEY, CACHE_KEY CACHE_KEY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, REQUEST_ID REQUEST_ID, START_DATE_ACTIVE_FIRST START_DATE_ACTIVE_FIRST, END_DATE_ACTIVE_FIRST END_DATE_ACTIVE_FIRST, START_DATE_ACTIVE_SECOND START_DATE_ACTIVE_SECOND, END_DATE_ACTIVE_SECOND END_DATE_ACTIVE_SECOND, START_DATE_ACTIVE_L START_DATE_ACTIVE_L, END_DATE_ACTIVE_L END_DATE_ACTIVE_L, START_DATE_ACTIVE_H START_DATE_ACTIVE_H, END_DATE_ACTIVE_H END_DATE_ACTIVE_H, GLOBAL_FLAG GLOBAL_FLAG, ORIG_ORG_ID ORIG_ORG_ID, HEADER_QUALS_EXIST_FLAG HEADER_QUALS_EXIST_FLAG, PRODUCT_UOM_CODE PRODUCT_UOM_CODE, ACTIVE_DATE_FIRST_TYPE ACTIVE_DATE_FIRST_TYPE, ACTIVE_DATE_SECOND_TYPE ACTIVE_DATE_SECOND_TYPE, EQ_FLAG EQ_FLAG, QUALIFY_HIER_DESCENDENTS_FLAG QUALIFY_HIER_DESCENDENTS_FLAG, LIST_LINE_TYPE_CODE LIST_LINE_TYPE_CODE, CURRENCY_HEADER_ID CURRENCY_HEADER_ID, OTHER_OPRT_COUNT OTHER_OPRT_COUNT, NULL_OTHER_OPRT_COUNT NULL_OTHER_OPRT_COUNT, HEADER_LIMIT_EXISTS HEADER_LIMIT_EXISTS, LINE_LIMIT_EXISTS LINE_LIMIT_EXISTS, PRICE_BREAK_TYPE_CODE PRICE_BREAK_TYPE_CODE, DESCENDENTS_QUALS_EXIST DESCENDENTS_QUALS_EXIST, PTE_CODE PTE_CODE, AUTOMATIC_FLAG AUTOMATIC_FLAG from "QP"."QP_ATTRIBUTE_GROUPS"

View Text - HTML Formatted

SELECT LIST_HEADER_ID LIST_HEADER_ID
, LIST_LINE_ID LIST_LINE_ID
, ACTIVE_FLAG ACTIVE_FLAG
, LIST_TYPE_CODE LIST_TYPE_CODE
, START_DATE_ACTIVE_Q START_DATE_ACTIVE_Q
, END_DATE_ACTIVE_Q END_DATE_ACTIVE_Q
, PATTERN_ID PATTERN_ID
, CURRENCY_CODE CURRENCY_CODE
, ASK_FOR_FLAG ASK_FOR_FLAG
, LIMIT_EXISTS LIMIT_EXISTS
, SOURCE_SYSTEM_CODE SOURCE_SYSTEM_CODE
, EFFECTIVE_PRECEDENCE EFFECTIVE_PRECEDENCE
, GROUPING_NO GROUPING_NO
, PRICING_PHASE_ID PRICING_PHASE_ID
, MODIFIER_LEVEL_CODE MODIFIER_LEVEL_CODE
, HASH_KEY HASH_KEY
, CACHE_KEY CACHE_KEY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, REQUEST_ID REQUEST_ID
, START_DATE_ACTIVE_FIRST START_DATE_ACTIVE_FIRST
, END_DATE_ACTIVE_FIRST END_DATE_ACTIVE_FIRST
, START_DATE_ACTIVE_SECOND START_DATE_ACTIVE_SECOND
, END_DATE_ACTIVE_SECOND END_DATE_ACTIVE_SECOND
, START_DATE_ACTIVE_L START_DATE_ACTIVE_L
, END_DATE_ACTIVE_L END_DATE_ACTIVE_L
, START_DATE_ACTIVE_H START_DATE_ACTIVE_H
, END_DATE_ACTIVE_H END_DATE_ACTIVE_H
, GLOBAL_FLAG GLOBAL_FLAG
, ORIG_ORG_ID ORIG_ORG_ID
, HEADER_QUALS_EXIST_FLAG HEADER_QUALS_EXIST_FLAG
, PRODUCT_UOM_CODE PRODUCT_UOM_CODE
, ACTIVE_DATE_FIRST_TYPE ACTIVE_DATE_FIRST_TYPE
, ACTIVE_DATE_SECOND_TYPE ACTIVE_DATE_SECOND_TYPE
, EQ_FLAG EQ_FLAG
, QUALIFY_HIER_DESCENDENTS_FLAG QUALIFY_HIER_DESCENDENTS_FLAG
, LIST_LINE_TYPE_CODE LIST_LINE_TYPE_CODE
, CURRENCY_HEADER_ID CURRENCY_HEADER_ID
, OTHER_OPRT_COUNT OTHER_OPRT_COUNT
, NULL_OTHER_OPRT_COUNT NULL_OTHER_OPRT_COUNT
, HEADER_LIMIT_EXISTS HEADER_LIMIT_EXISTS
, LINE_LIMIT_EXISTS LINE_LIMIT_EXISTS
, PRICE_BREAK_TYPE_CODE PRICE_BREAK_TYPE_CODE
, DESCENDENTS_QUALS_EXIST DESCENDENTS_QUALS_EXIST
, PTE_CODE PTE_CODE
, AUTOMATIC_FLAG AUTOMATIC_FLAG
FROM "QP"."QP_ATTRIBUTE_GROUPS"