VIEW: QP.QP_INTERFACE_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, PROCESS_ID PROCESS_ID, PROCESS_TYPE PROCESS_TYPE, INTERFACE_ACTION_CODE INTERFACE_ACTION_CODE, LOCK_FLAG LOCK_FLAG, PROCESS_FLAG PROCESS_FLAG, DELETE_FLAG DELETE_FLAG, PROCESS_STATUS_FLAG PROCESS_STATUS_FLAG, 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, INCLUDE_ON_RETURNS_FLAG INCLUDE_ON_RETURNS_FLAG, QUALIFICATION_IND QUALIFICATION_IND, 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, RLTD_MODIFIER_GRP_NO RLTD_MODIFIER_GRP_NO, RLTD_MODIFIER_GRP_TYPE RLTD_MODIFIER_GRP_TYPE, PRICE_BREAK_HEADER_INDEX PRICE_BREAK_HEADER_INDEX, PRICING_PHASE_NAME PRICING_PHASE_NAME, RECURRING_VALUE RECURRING_VALUE, NET_AMOUNT_FLAG NET_AMOUNT_FLAG, ATTRIBUTE_STATUS ATTRIBUTE_STATUS, ORIG_SYS_LINE_REF ORIG_SYS_LINE_REF, ORIG_SYS_HEADER_REF ORIG_SYS_HEADER_REF, PRICE_BREAK_HEADER_REF PRICE_BREAK_HEADER_REF, GENERATE_USING_FORMULA GENERATE_USING_FORMULA, PRICE_BY_FORMULA PRICE_BY_FORMULA, CONTINUOUS_PRICE_BREAK_FLAG CONTINUOUS_PRICE_BREAK_FLAG from "QP"."QP_INTERFACE_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
, PROCESS_ID PROCESS_ID
, PROCESS_TYPE PROCESS_TYPE
, INTERFACE_ACTION_CODE INTERFACE_ACTION_CODE
, LOCK_FLAG LOCK_FLAG
, PROCESS_FLAG PROCESS_FLAG
, DELETE_FLAG DELETE_FLAG
, PROCESS_STATUS_FLAG PROCESS_STATUS_FLAG
, 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
, INCLUDE_ON_RETURNS_FLAG INCLUDE_ON_RETURNS_FLAG
, QUALIFICATION_IND QUALIFICATION_IND
, 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
, RLTD_MODIFIER_GRP_NO RLTD_MODIFIER_GRP_NO
, RLTD_MODIFIER_GRP_TYPE RLTD_MODIFIER_GRP_TYPE
, PRICE_BREAK_HEADER_INDEX PRICE_BREAK_HEADER_INDEX
, PRICING_PHASE_NAME PRICING_PHASE_NAME
, RECURRING_VALUE RECURRING_VALUE
, NET_AMOUNT_FLAG NET_AMOUNT_FLAG
, ATTRIBUTE_STATUS ATTRIBUTE_STATUS
, ORIG_SYS_LINE_REF ORIG_SYS_LINE_REF
, ORIG_SYS_HEADER_REF ORIG_SYS_HEADER_REF
, PRICE_BREAK_HEADER_REF PRICE_BREAK_HEADER_REF
, GENERATE_USING_FORMULA GENERATE_USING_FORMULA
, PRICE_BY_FORMULA PRICE_BY_FORMULA
, CONTINUOUS_PRICE_BREAK_FLAG CONTINUOUS_PRICE_BREAK_FLAG
FROM "QP"."QP_INTERFACE_LIST_LINES"