VIEW: APPS.QP_LISTS_V

Source

View Text - Preformatted

SELECT qph.ROW_ID ROW_ID, qph.CURRENCY_CODE, qph.SHIP_METHOD_CODE, qph.FREIGHT_TERMS_CODE, qph.LIST_HEADER_ID, qph.CREATION_DATE, qph.START_DATE_ACTIVE QPH_START_DATE_ACTIVE, qph.END_DATE_ACTIVE QPH_END_DATE_ACTIVE, qph.LIST_TYPE_CODE, qph.TERMS_ID, qph.ROUNDING_FACTOR, qph.DISCOUNT_LINES_FLAG, qph.NAME, qph.DESCRIPTION, qph.VERSION_NO, qph.COMMENTS, qph.GSA_INDICATOR, qph.PRORATE_FLAG, qph.SOURCE_SYSTEM_CODE, qph.ACTIVE_FLAG, qph.PARENT_LIST_HEADER_ID, qph.START_DATE_ACTIVE_FIRST, qph.END_DATE_ACTIVE_FIRST, qph.ACTIVE_DATE_FIRST_TYPE, qph.START_DATE_ACTIVE_SECOND, qph.END_DATE_ACTIVE_SECOND, qph.ACTIVE_DATE_SECOND_TYPE, qph.ASK_FOR_FLAG, qpl.LIST_LINE_ID, qpl.LIST_LINE_TYPE_CODE, qpl.AUTOMATIC_FLAG, qpl.MODIFIER_LEVEL_CODE, qpl.LIST_PRICE, qpl.PRIMARY_UOM_FLAG, qpl.INVENTORY_ITEM_ID, qpl.ORGANIZATION_ID, qpl.RELATED_ITEM_ID, qpl.RELATIONSHIP_TYPE_ID, qpl.SUBSTITUTION_CONTEXT, qpl.SUBSTITUTION_ATTRIBUTE, qpl.SUBSTITUTION_VALUE, qpl.REVISION, qpl.REVISION_DATE, qpl.REVISION_REASON_CODE, qpl.PRICE_BREAK_TYPE_CODE, qpl.PERCENT_PRICE, qpl.PRICE_BY_FORMULA_ID, qpl.NUMBER_EFFECTIVE_PERIODS, qpl.EFFECTIVE_PERIOD_UOM, qpl.ARITHMETIC_OPERATOR, qpl.OPERAND, qpl.OVERRIDE_FLAG, qpl.PRINT_ON_INVOICE_FLAG, qpl.REBATE_TRANSACTION_TYPE_CODE, qpl.BASE_QTY, qpl.BASE_UOM_CODE, qpl.ACCRUAL_QTY, qpl.ACCRUAL_UOM_CODE, qpl.ESTIM_ACCRUAL_RATE, qpl.GENERATE_USING_FORMULA_ID, qpl.START_DATE_ACTIVE QPL_START_DATE_ACTIVE, qpl.END_DATE_ACTIVE QPL_END_DATE_ACTIVE, qpl.REPRICE_FLAG, qpl.ACCRUAL_FLAG, qpl.PRICING_GROUP_SEQUENCE, qpl.INCOMPATIBILITY_GRP_CODE, qpl.LIST_LINE_NO, qpl.PRICING_PHASE_ID, qpl.PRODUCT_PRECEDENCE, qpl.LIST_PRICE_UOM_CODE, qpl.EXPIRATION_PERIOD_START_DATE, qpl.NUMBER_EXPIRATION_PERIODS, qpl.EXPIRATION_PERIOD_UOM, qpl.EXPIRATION_DATE from qp_list_Headers_vl qph, qp_list_lines qpl WHERE qph.List_Header_id = qpl.List_Header_id

View Text - HTML Formatted

SELECT QPH.ROW_ID ROW_ID
, QPH.CURRENCY_CODE
, QPH.SHIP_METHOD_CODE
, QPH.FREIGHT_TERMS_CODE
, QPH.LIST_HEADER_ID
, QPH.CREATION_DATE
, QPH.START_DATE_ACTIVE QPH_START_DATE_ACTIVE
, QPH.END_DATE_ACTIVE QPH_END_DATE_ACTIVE
, QPH.LIST_TYPE_CODE
, QPH.TERMS_ID
, QPH.ROUNDING_FACTOR
, QPH.DISCOUNT_LINES_FLAG
, QPH.NAME
, QPH.DESCRIPTION
, QPH.VERSION_NO
, QPH.COMMENTS
, QPH.GSA_INDICATOR
, QPH.PRORATE_FLAG
, QPH.SOURCE_SYSTEM_CODE
, QPH.ACTIVE_FLAG
, QPH.PARENT_LIST_HEADER_ID
, QPH.START_DATE_ACTIVE_FIRST
, QPH.END_DATE_ACTIVE_FIRST
, QPH.ACTIVE_DATE_FIRST_TYPE
, QPH.START_DATE_ACTIVE_SECOND
, QPH.END_DATE_ACTIVE_SECOND
, QPH.ACTIVE_DATE_SECOND_TYPE
, QPH.ASK_FOR_FLAG
, QPL.LIST_LINE_ID
, QPL.LIST_LINE_TYPE_CODE
, QPL.AUTOMATIC_FLAG
, QPL.MODIFIER_LEVEL_CODE
, QPL.LIST_PRICE
, QPL.PRIMARY_UOM_FLAG
, QPL.INVENTORY_ITEM_ID
, QPL.ORGANIZATION_ID
, QPL.RELATED_ITEM_ID
, QPL.RELATIONSHIP_TYPE_ID
, QPL.SUBSTITUTION_CONTEXT
, QPL.SUBSTITUTION_ATTRIBUTE
, QPL.SUBSTITUTION_VALUE
, QPL.REVISION
, QPL.REVISION_DATE
, QPL.REVISION_REASON_CODE
, QPL.PRICE_BREAK_TYPE_CODE
, QPL.PERCENT_PRICE
, QPL.PRICE_BY_FORMULA_ID
, QPL.NUMBER_EFFECTIVE_PERIODS
, QPL.EFFECTIVE_PERIOD_UOM
, QPL.ARITHMETIC_OPERATOR
, QPL.OPERAND
, QPL.OVERRIDE_FLAG
, QPL.PRINT_ON_INVOICE_FLAG
, QPL.REBATE_TRANSACTION_TYPE_CODE
, QPL.BASE_QTY
, QPL.BASE_UOM_CODE
, QPL.ACCRUAL_QTY
, QPL.ACCRUAL_UOM_CODE
, QPL.ESTIM_ACCRUAL_RATE
, QPL.GENERATE_USING_FORMULA_ID
, QPL.START_DATE_ACTIVE QPL_START_DATE_ACTIVE
, QPL.END_DATE_ACTIVE QPL_END_DATE_ACTIVE
, QPL.REPRICE_FLAG
, QPL.ACCRUAL_FLAG
, QPL.PRICING_GROUP_SEQUENCE
, QPL.INCOMPATIBILITY_GRP_CODE
, QPL.LIST_LINE_NO
, QPL.PRICING_PHASE_ID
, QPL.PRODUCT_PRECEDENCE
, QPL.LIST_PRICE_UOM_CODE
, QPL.EXPIRATION_PERIOD_START_DATE
, QPL.NUMBER_EXPIRATION_PERIODS
, QPL.EXPIRATION_PERIOD_UOM
, QPL.EXPIRATION_DATE
FROM QP_LIST_HEADERS_VL QPH
, QP_LIST_LINES QPL
WHERE QPH.LIST_HEADER_ID = QPL.LIST_HEADER_ID