View: OE_RETROBILLED_INFO_V

Product:	ONT - Order Management
Description:	View is to show retrobilled activities
Implementation/DBA Data:	APPS.OE_RETROBILLED_INFO_V

View Text

SELECT ORIG_LIN.LINE_NUMBER
, ORIG_LIN.SHIPMENT_NUMBER ORIG_SHIPMENT_NUMBER
, ORIG_LIN.OPTION_NUMBER ORIG_OPTION_NUMBER
, ORIG_LIN.COMPONENT_NUMBER ORIG_COMPONENT_NUMBER
, ORIG_LIN.SERVICE_NUMBER ORIG_SERVICE_NUMBER
, ORIG_LIN.ORDERED_ITEM
, RETRO_LIN.PRICING_DATE
, DECODE(RETRO_LIN.LINE_CATEGORY_CODE
, 'RETURN'
, -1*RETRO_LIN.ORDERED_QUANTITY
, RETRO_LIN.ORDERED_QUANTITY) QTY
, RETRO_LIN.UNIT_SELLING_PRICE
, DECODE(RETRO_LIN.LINE_CATEGORY_CODE
, 'RETURN'
, -1*RETRO_LIN.UNIT_SELLING_PRICE*RETRO_LIN.ORDERED_QUANTITY
, RETRO_LIN.UNIT_SELLING_PRICE*RETRO_LIN.ORDERED_QUANTITY) AMOUNT
, OH.ORDER_NUMBER RETROBILL_ORDER_NUMBER
, RETRO_LIN.LINE_NUMBER RETROBILL_LINE_NUMBER
, RETRO_LIN.SHIPMENT_NUMBER
, RETRO_LIN.OPTION_NUMBER
, RETRO_LIN.COMPONENT_NUMBER
, RETRO_LIN.SERVICE_NUMBER
, RETRO_LIN.INVOICED_QUANTITY
, RETRO_LIN.ITEM_IDENTIFIER_TYPE
, RETRO_LIN.ORDER_QUANTITY_UOM
, OTT.NAME
, ORIG_LIN.HEADER_ID
, ORIG_LIN.LINE_ID
, RETRO_LIN.HEADER_ID RETROBILL_HEADER_ID
, RETRO_LIN.LINE_ID RETROBILL_LINE_ID
FROM OE_ORDER_LINES_ALL ORIG_LIN
, OE_ORDER_LINES_ALL RETRO_LIN
, OE_ORDER_HEADERS OH
, OE_TRANSACTION_TYPES_TL OTT
WHERE RETRO_LIN.ORDER_SOURCE_ID = 27
AND RETRO_LIN.ORIG_SYS_DOCUMENT_REF = TO_CHAR(ORIG_LIN.HEADER_ID)
AND RETRO_LIN.ORIG_SYS_LINE_REF = TO_CHAR(ORIG_LIN.LINE_ID)
AND OH.HEADER_ID = RETRO_LIN.HEADER_ID
AND OH.ORDER_TYPE_ID = OTT.TRANSACTION_TYPE_ID
AND OTT.LANGUAGE = (SELECT LANGUAGE_CODE
FROM FND_LANGUAGES
WHERE INSTALLED_FLAG = 'B')

Columns