VIEW: QP.QP_LIST_LINES#

Source

View Text - Preformatted

select LIST_LINE_ID LIST_LINE_ID, 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, LIST_HEADER_ID LIST_HEADER_ID, LIST_LINE_TYPE_CODE LIST_LINE_TYPE_CODE, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, AUTOMATIC_FLAG AUTOMATIC_FLAG, MODIFIER_LEVEL_CODE MODIFIER_LEVEL_CODE, PRICE_BY_FORMULA_ID PRICE_BY_FORMULA_ID, LIST_PRICE LIST_PRICE, LIST_PRICE_UOM_CODE LIST_PRICE_UOM_CODE, PRIMARY_UOM_FLAG PRIMARY_UOM_FLAG, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, RELATED_ITEM_ID RELATED_ITEM_ID, RELATIONSHIP_TYPE_ID RELATIONSHIP_TYPE_ID, SUBSTITUTION_CONTEXT SUBSTITUTION_CONTEXT, SUBSTITUTION_ATTRIBUTE SUBSTITUTION_ATTRIBUTE, SUBSTITUTION_VALUE SUBSTITUTION_VALUE, REVISION REVISION, REVISION_DATE REVISION_DATE, REVISION_REASON_CODE REVISION_REASON_CODE, PRICE_BREAK_TYPE_CODE PRICE_BREAK_TYPE_CODE, PERCENT_PRICE PERCENT_PRICE, NUMBER_EFFECTIVE_PERIODS NUMBER_EFFECTIVE_PERIODS, EFFECTIVE_PERIOD_UOM EFFECTIVE_PERIOD_UOM, ARITHMETIC_OPERATOR ARITHMETIC_OPERATOR, OPERAND OPERAND, OVERRIDE_FLAG OVERRIDE_FLAG, PRINT_ON_INVOICE_FLAG PRINT_ON_INVOICE_FLAG, REBATE_TRANSACTION_TYPE_CODE REBATE_TRANSACTION_TYPE_CODE, BASE_QTY BASE_QTY, BASE_UOM_CODE BASE_UOM_CODE, ACCRUAL_QTY ACCRUAL_QTY, ACCRUAL_UOM_CODE ACCRUAL_UOM_CODE, ESTIM_ACCRUAL_RATE ESTIM_ACCRUAL_RATE, COMMENTS COMMENTS, GENERATE_USING_FORMULA_ID GENERATE_USING_FORMULA_ID, REPRICE_FLAG REPRICE_FLAG, LIST_LINE_NO LIST_LINE_NO, ESTIM_GL_VALUE ESTIM_GL_VALUE, BENEFIT_PRICE_LIST_LINE_ID BENEFIT_PRICE_LIST_LINE_ID, EXPIRATION_PERIOD_START_DATE EXPIRATION_PERIOD_START_DATE, NUMBER_EXPIRATION_PERIODS NUMBER_EXPIRATION_PERIODS, EXPIRATION_PERIOD_UOM EXPIRATION_PERIOD_UOM, EXPIRATION_DATE EXPIRATION_DATE, ACCRUAL_FLAG ACCRUAL_FLAG, PRICING_PHASE_ID PRICING_PHASE_ID, PRICING_GROUP_SEQUENCE PRICING_GROUP_SEQUENCE, INCOMPATIBILITY_GRP_CODE INCOMPATIBILITY_GRP_CODE, PRODUCT_PRECEDENCE PRODUCT_PRECEDENCE, PRORATION_TYPE_CODE PRORATION_TYPE_CODE, ACCRUAL_CONVERSION_RATE ACCRUAL_CONVERSION_RATE, BENEFIT_QTY BENEFIT_QTY, BENEFIT_UOM_CODE BENEFIT_UOM_CODE, RECURRING_FLAG RECURRING_FLAG, BENEFIT_LIMIT BENEFIT_LIMIT, CHARGE_TYPE_CODE CHARGE_TYPE_CODE, CHARGE_SUBTYPE_CODE CHARGE_SUBTYPE_CODE, CONTEXT CONTEXT, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, INCLUDE_ON_RETURNS_FLAG INCLUDE_ON_RETURNS_FLAG, QUALIFICATION_IND QUALIFICATION_IND, LIMIT_EXISTS_FLAG LIMIT_EXISTS_FLAG, GROUP_COUNT GROUP_COUNT, NET_AMOUNT_FLAG NET_AMOUNT_FLAG, RECURRING_VALUE RECURRING_VALUE, ACCUM_CONTEXT ACCUM_CONTEXT, ACCUM_ATTRIBUTE ACCUM_ATTRIBUTE, ACCUM_ATTR_RUN_SRC_FLAG ACCUM_ATTR_RUN_SRC_FLAG, CUSTOMER_ITEM_ID CUSTOMER_ITEM_ID, BREAK_UOM_CODE BREAK_UOM_CODE, BREAK_UOM_CONTEXT BREAK_UOM_CONTEXT, BREAK_UOM_ATTRIBUTE BREAK_UOM_ATTRIBUTE, PATTERN_ID PATTERN_ID, PRODUCT_UOM_CODE PRODUCT_UOM_CODE, PRICING_ATTRIBUTE_COUNT PRICING_ATTRIBUTE_COUNT, HASH_KEY HASH_KEY, CACHE_KEY CACHE_KEY, ORIG_SYS_LINE_REF ORIG_SYS_LINE_REF, ORIG_SYS_HEADER_REF ORIG_SYS_HEADER_REF, CONTINUOUS_PRICE_BREAK_FLAG CONTINUOUS_PRICE_BREAK_FLAG, EQ_FLAG EQ_FLAG, CURRENCY_HEADER_ID CURRENCY_HEADER_ID, NULL_OTHER_OPRT_COUNT NULL_OTHER_OPRT_COUNT, PTE_CODE PTE_CODE, SOURCE_SYSTEM_CODE SOURCE_SYSTEM_CODE, SERVICE_DURATION SERVICE_DURATION, SERVICE_PERIOD SERVICE_PERIOD from "QP"."QP_LIST_LINES"

View Text - HTML Formatted

SELECT LIST_LINE_ID LIST_LINE_ID
, 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
, LIST_HEADER_ID LIST_HEADER_ID
, LIST_LINE_TYPE_CODE LIST_LINE_TYPE_CODE
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, AUTOMATIC_FLAG AUTOMATIC_FLAG
, MODIFIER_LEVEL_CODE MODIFIER_LEVEL_CODE
, PRICE_BY_FORMULA_ID PRICE_BY_FORMULA_ID
, LIST_PRICE LIST_PRICE
, LIST_PRICE_UOM_CODE LIST_PRICE_UOM_CODE
, PRIMARY_UOM_FLAG PRIMARY_UOM_FLAG
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, RELATED_ITEM_ID RELATED_ITEM_ID
, RELATIONSHIP_TYPE_ID RELATIONSHIP_TYPE_ID
, SUBSTITUTION_CONTEXT SUBSTITUTION_CONTEXT
, SUBSTITUTION_ATTRIBUTE SUBSTITUTION_ATTRIBUTE
, SUBSTITUTION_VALUE SUBSTITUTION_VALUE
, REVISION REVISION
, REVISION_DATE REVISION_DATE
, REVISION_REASON_CODE REVISION_REASON_CODE
, PRICE_BREAK_TYPE_CODE PRICE_BREAK_TYPE_CODE
, PERCENT_PRICE PERCENT_PRICE
, NUMBER_EFFECTIVE_PERIODS NUMBER_EFFECTIVE_PERIODS
, EFFECTIVE_PERIOD_UOM EFFECTIVE_PERIOD_UOM
, ARITHMETIC_OPERATOR ARITHMETIC_OPERATOR
, OPERAND OPERAND
, OVERRIDE_FLAG OVERRIDE_FLAG
, PRINT_ON_INVOICE_FLAG PRINT_ON_INVOICE_FLAG
, REBATE_TRANSACTION_TYPE_CODE REBATE_TRANSACTION_TYPE_CODE
, BASE_QTY BASE_QTY
, BASE_UOM_CODE BASE_UOM_CODE
, ACCRUAL_QTY ACCRUAL_QTY
, ACCRUAL_UOM_CODE ACCRUAL_UOM_CODE
, ESTIM_ACCRUAL_RATE ESTIM_ACCRUAL_RATE
, COMMENTS COMMENTS
, GENERATE_USING_FORMULA_ID GENERATE_USING_FORMULA_ID
, REPRICE_FLAG REPRICE_FLAG
, LIST_LINE_NO LIST_LINE_NO
, ESTIM_GL_VALUE ESTIM_GL_VALUE
, BENEFIT_PRICE_LIST_LINE_ID BENEFIT_PRICE_LIST_LINE_ID
, EXPIRATION_PERIOD_START_DATE EXPIRATION_PERIOD_START_DATE
, NUMBER_EXPIRATION_PERIODS NUMBER_EXPIRATION_PERIODS
, EXPIRATION_PERIOD_UOM EXPIRATION_PERIOD_UOM
, EXPIRATION_DATE EXPIRATION_DATE
, ACCRUAL_FLAG ACCRUAL_FLAG
, PRICING_PHASE_ID PRICING_PHASE_ID
, PRICING_GROUP_SEQUENCE PRICING_GROUP_SEQUENCE
, INCOMPATIBILITY_GRP_CODE INCOMPATIBILITY_GRP_CODE
, PRODUCT_PRECEDENCE PRODUCT_PRECEDENCE
, PRORATION_TYPE_CODE PRORATION_TYPE_CODE
, ACCRUAL_CONVERSION_RATE ACCRUAL_CONVERSION_RATE
, BENEFIT_QTY BENEFIT_QTY
, BENEFIT_UOM_CODE BENEFIT_UOM_CODE
, RECURRING_FLAG RECURRING_FLAG
, BENEFIT_LIMIT BENEFIT_LIMIT
, CHARGE_TYPE_CODE CHARGE_TYPE_CODE
, CHARGE_SUBTYPE_CODE CHARGE_SUBTYPE_CODE
, CONTEXT CONTEXT
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, INCLUDE_ON_RETURNS_FLAG INCLUDE_ON_RETURNS_FLAG
, QUALIFICATION_IND QUALIFICATION_IND
, LIMIT_EXISTS_FLAG LIMIT_EXISTS_FLAG
, GROUP_COUNT GROUP_COUNT
, NET_AMOUNT_FLAG NET_AMOUNT_FLAG
, RECURRING_VALUE RECURRING_VALUE
, ACCUM_CONTEXT ACCUM_CONTEXT
, ACCUM_ATTRIBUTE ACCUM_ATTRIBUTE
, ACCUM_ATTR_RUN_SRC_FLAG ACCUM_ATTR_RUN_SRC_FLAG
, CUSTOMER_ITEM_ID CUSTOMER_ITEM_ID
, BREAK_UOM_CODE BREAK_UOM_CODE
, BREAK_UOM_CONTEXT BREAK_UOM_CONTEXT
, BREAK_UOM_ATTRIBUTE BREAK_UOM_ATTRIBUTE
, PATTERN_ID PATTERN_ID
, PRODUCT_UOM_CODE PRODUCT_UOM_CODE
, PRICING_ATTRIBUTE_COUNT PRICING_ATTRIBUTE_COUNT
, HASH_KEY HASH_KEY
, CACHE_KEY CACHE_KEY
, ORIG_SYS_LINE_REF ORIG_SYS_LINE_REF
, ORIG_SYS_HEADER_REF ORIG_SYS_HEADER_REF
, CONTINUOUS_PRICE_BREAK_FLAG CONTINUOUS_PRICE_BREAK_FLAG
, EQ_FLAG EQ_FLAG
, CURRENCY_HEADER_ID CURRENCY_HEADER_ID
, NULL_OTHER_OPRT_COUNT NULL_OTHER_OPRT_COUNT
, PTE_CODE PTE_CODE
, SOURCE_SYSTEM_CODE SOURCE_SYSTEM_CODE
, SERVICE_DURATION SERVICE_DURATION
, SERVICE_PERIOD SERVICE_PERIOD
FROM "QP"."QP_LIST_LINES"