FND Design Data [Home] [Help]

View: OE_RETROBILLED_INFO_V

Product: ONT - Order Management
Description: View is to show retrobilled activities
Implementation/DBA Data: ViewAPPS.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

Name
LINE_NUMBER
ORIG_SHIPMENT_NUMBER
ORIG_OPTION_NUMBER
ORIG_COMPONENT_NUMBER
ORIG_SERVICE_NUMBER
ORDERED_ITEM
PRICING_DATE
QTY
UNIT_SELLING_PRICE
AMOUNT
RETROBILL_ORDER_NUMBER
RETROBILL_LINE_NUMBER
SHIPMENT_NUMBER
OPTION_NUMBER
COMPONENT_NUMBER
SERVICE_NUMBER
INVOICED_QUANTITY
ITEM_IDENTIFIER_TYPE
ORDER_QUANTITY_UOM
NAME
HEADER_ID
LINE_ID
RETROBILL_HEADER_ID
RETROBILL_LINE_ID