Product: | OKX - Contracts Integration |
---|---|
Description: | |
Implementation/DBA Data: |
![]() |
SELECT QPL.LIST_LINE_ID ID1
, '#' ID2
, QPL.LIST_HEADER_ID LIST_HEADER_ID
, QPL.LIST_LINE_TYPE_CODE LIST_LINE_TYPE_CODE
, QPL.START_DATE_ACTIVE START_DATE_ACTIVE
, QPL.END_DATE_ACTIVE END_DATE_ACTIVE
, QPL.AUTOMATIC_FLAG AUTOMATIC_FLAG
, QPL.MODIFIER_LEVEL_CODE MODIFIER_LEVEL_CODE
, QPL.PRICE_BY_FORMULA_ID PRICE_BY_FORMULA_ID
, QPL.LIST_PRICE LIST_PRICE
, QPL.LIST_PRICE_UOM_CODE LIST_PRICE_UOM_CODE
, QPL.PRIMARY_UOM_FLAG PRIMARY_UOM_FLAG
, QPL.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, QPL.ORGANIZATION_ID ORGANIZATION_ID
, QPL.PRICE_BREAK_TYPE_CODE PRICE_BREAK_TYPE_CODE
, QPL.PERCENT_PRICE PERCENT_PRICE
, QPL.ARITHMETIC_OPERATOR ARITHMETIC_OPERATOR
, QPL.OPERAND OPERAND
, QPL.OVERRIDE_FLAG OVERRIDE_FLAG
, QPL.LIST_LINE_NO LIST_LINE_NO
, QPL.PRICING_PHASE_ID PRICING_PHASE_ID
, QPL.PRICING_GROUP_SEQUENCE PRICING_GROUP_SEQUENCE
FROM QP_LIST_LINES QPL