VIEW: APPS.OEFV_PRICE_ADJUSTMENTS

Source

View Text - Preformatted

SELECT PRADJ.PRICE_ADJUSTMENT_ID , '_LA:PRADJ.AUTOMATIC_FLAG:OE_LOOKUPS:YES_NO:MEANING', PRADJ.PERCENT, '_DF:ONT:OE_PRICE_ADJUSTMENTS:PRADJ', DISCOUNT.NAME, HEADER.ORDER_NUMBER, PRADJ.DISCOUNT_ID, PRADJ.DISCOUNT_LINE_ID, PRADJ.HEADER_ID, PRADJ.LINE_ID, PRADJ.LAST_UPDATE_DATE, PRADJ.LAST_UPDATED_BY, PRADJ.CREATION_DATE, PRADJ.CREATED_BY, '_LA:PRADJ.APPLIED_FLAG:OE_LOOKUPS:YES_NO:MEANING', PRADJ.OPERAND, PRADJ.ARITHMETIC_OPERATOR, '_LA:PRADJ.CHANGE_REASON_CODE:OE_LOOKUPS:CHANGE_CODE:MEANING', '_LA:PRADJ.LIST_LINE_TYPE_CODE:QP_LOOKUPS:LIST_LINE_TYPE_CODE:MEANING', PRADJ.LIST_HEADER_ID, PRADJ.LIST_LINE_ID FROM OE_PRICE_ADJUSTMENTS PRADJ , QP_LIST_HEADERS_TL DISCOUNT, OE_ORDER_HEADERS_ALL HEADER WHERE PRADJ.LIST_HEADER_ID = DISCOUNT.LIST_HEADER_ID (+) AND DISCOUNT.LANGUAGE = userenv('LANG') AND PRADJ.HEADER_ID = HEADER.HEADER_ID WITH READ ONLY

View Text - HTML Formatted

SELECT PRADJ.PRICE_ADJUSTMENT_ID
, '_LA:PRADJ.AUTOMATIC_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, PRADJ.PERCENT
, '_DF:ONT:OE_PRICE_ADJUSTMENTS:PRADJ'
, DISCOUNT.NAME
, HEADER.ORDER_NUMBER
, PRADJ.DISCOUNT_ID
, PRADJ.DISCOUNT_LINE_ID
, PRADJ.HEADER_ID
, PRADJ.LINE_ID
, PRADJ.LAST_UPDATE_DATE
, PRADJ.LAST_UPDATED_BY
, PRADJ.CREATION_DATE
, PRADJ.CREATED_BY
, '_LA:PRADJ.APPLIED_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, PRADJ.OPERAND
, PRADJ.ARITHMETIC_OPERATOR
, '_LA:PRADJ.CHANGE_REASON_CODE:OE_LOOKUPS:CHANGE_CODE:MEANING'
, '_LA:PRADJ.LIST_LINE_TYPE_CODE:QP_LOOKUPS:LIST_LINE_TYPE_CODE:MEANING'
, PRADJ.LIST_HEADER_ID
, PRADJ.LIST_LINE_ID
FROM OE_PRICE_ADJUSTMENTS PRADJ
, QP_LIST_HEADERS_TL DISCOUNT
, OE_ORDER_HEADERS_ALL HEADER
WHERE PRADJ.LIST_HEADER_ID = DISCOUNT.LIST_HEADER_ID (+)
AND DISCOUNT.LANGUAGE = USERENV('LANG')
AND PRADJ.HEADER_ID = HEADER.HEADER_ID WITH READ ONLY