eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OE_RETROBILLED_INFO_V

Source

View Text - Preformatted


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')

View Text - HTML Formatted

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')