VIEW: APPS.QPFV_PRICE_LIST_LINES

Source

View Text - Preformatted

SELECT ll.LIST_HEADER_ID ,ll.PRICE_BY_FORMULA_ID ,ll.GENERATE_USING_FORMULA_ID ,ll.OPERAND ,ll.START_DATE_ACTIVE ,ll.END_DATE_ACTIVE ,ll.PRODUCT_PRECEDENCE ,ll.ARITHMETIC_OPERATOR ,'_LA:ll.ARITHMETIC_OPERATOR:QP_LOOKUPS:ARITHMETIC_OPERATOR:MEANING' ,ll.LIST_LINE_TYPE_CODE ,'_LA:ll.LIST_LINE_TYPE_CODE:QP_LOOKUPS:LIST_LINE_TYPE_CODE:MEANING' ,ll.PRICE_BREAK_TYPE_CODE ,'_LA:ll.PRICE_BREAK_TYPE_CODE:QP_LOOKUPS:PRICE_BREAK_TYPE_CODE:MEANING' ,ll.LIST_LINE_ID ,ll.CREATION_DATE ,ll.CREATED_BY ,ll.LAST_UPDATE_DATE ,ll.LAST_UPDATED_BY , '_DF:QP:QP_LIST_LINES:ll' ,ll.CUSTOMER_ITEM_ID ,ll.ORIG_SYS_HEADER_REF ,ll.ORIG_SYS_LINE_REF from qp_list_lines ll WHERE ll.list_line_type_code = 'PLL' and not exists ( select 'x' from qp_rltd_modifiers rltd where ll.list_line_id = rltd.to_rltd_modifier_id)

View Text - HTML Formatted

SELECT LL.LIST_HEADER_ID
, LL.PRICE_BY_FORMULA_ID
, LL.GENERATE_USING_FORMULA_ID
, LL.OPERAND
, LL.START_DATE_ACTIVE
, LL.END_DATE_ACTIVE
, LL.PRODUCT_PRECEDENCE
, LL.ARITHMETIC_OPERATOR
, '_LA:LL.ARITHMETIC_OPERATOR:QP_LOOKUPS:ARITHMETIC_OPERATOR:MEANING'
, LL.LIST_LINE_TYPE_CODE
, '_LA:LL.LIST_LINE_TYPE_CODE:QP_LOOKUPS:LIST_LINE_TYPE_CODE:MEANING'
, LL.PRICE_BREAK_TYPE_CODE
, '_LA:LL.PRICE_BREAK_TYPE_CODE:QP_LOOKUPS:PRICE_BREAK_TYPE_CODE:MEANING'
, LL.LIST_LINE_ID
, LL.CREATION_DATE
, LL.CREATED_BY
, LL.LAST_UPDATE_DATE
, LL.LAST_UPDATED_BY
, '_DF:QP:QP_LIST_LINES:LL'
, LL.CUSTOMER_ITEM_ID
, LL.ORIG_SYS_HEADER_REF
, LL.ORIG_SYS_LINE_REF
FROM QP_LIST_LINES LL
WHERE LL.LIST_LINE_TYPE_CODE = 'PLL'
AND NOT EXISTS ( SELECT 'X'
FROM QP_RLTD_MODIFIERS RLTD
WHERE LL.LIST_LINE_ID = RLTD.TO_RLTD_MODIFIER_ID)