VIEW: APPS.OKX_QP_LIST_LINES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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