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_ORDER_LINES_RM_V

Source

View Text - Preformatted


SELECT
oel.line_id,
oel.header_id,
'SALES_ORDER' DOCUMENT_TYPE_CODE,
oel.ORG_ID,
oel.LINE_NUMBER,
LT.NAME LINE_TYPE ,
oel.FLOW_STATUS_CODE,
oel.INVENTORY_ITEM_ID,
oel.ORDERED_ITEM ,
oel.ORDER_QUANTITY_UOM ,
Decode (oel.line_category_code, 'ORDER',oel.ORDERED_QUANTITY  ,'RETURN' , -1*oel.ORDERED_QUANTITY , oel.ORDERED_QUANTITY) ORDERED_QUANTITY,
oel.UNIT_SELLING_PRICE ,
oel.UNIT_LIST_PRICE     ,
oel.UNIT_SELLING_PERCENT,
oel.UNIT_LIST_PERCENT,
oel.UNIT_PERCENT_BASE_PRICE,
Decode (oel.line_category_code, 'ORDER',oel.UNIT_SELLING_PRICE * oel.ORDERED_QUANTITY ,'RETURN' , -1*oel.UNIT_SELLING_PRICE * oel.ORDERED_QUANTITY , oel.UNIT_SELLING_PRICE * oel.ORDERED_QUANTITY) LINE_AMOUNT,
oel.SCHEDULE_SHIP_DATE   ,
oel.CANCELLED_QUANTITY ,
oel.SHIPPED_QUANTITY,
oel.FULFILLED_QUANTITY,
oel.SHIPPING_QUANTITY  ,
oel.SHIPPING_QUANTITY_UOM,
NULL invoicable_flag ,
NULL shippable_flag,
decode(nvl(oel.shipped_quantity,0),0,'N', 'Y')  shipped_flag,
decode(nvl(oel.invoiced_quantity,0),0,'N', 'Y')  invoiced_flag,
oel.DELIVERY_LEAD_TIME    ,
oel.INVOICE_TO_ORG_ID ,
oel.CUST_PO_NUMBER ,
oel.PROJECT_ID      ,
oel.TASK_ID          ,
oel.INVOICE_INTERFACE_STATUS_CODE ,
oel.FULFILLED_FLAG ,
oel.CANCELLED_FLAG  ,
oel.SHIPMENT_NUMBER  ,
oel.SHIPMENT_PRIORITY_CODE ,
oel.SHIPPING_METHOD_CODE    ,
oel.FREIGHT_CARRIER_CODE     ,
oel.FREIGHT_TERMS_CODE  ,
oel.FOB_POINT_CODE  ,
oel.PAYMENT_TERM_ID  ,
oel.ACCOUNTING_RULE_ID ,
oel.SOURCE_DOCUMENT_TYPE_ID ,
oel.ORIG_SYS_DOCUMENT_REF  ,
oel.SOURCE_DOCUMENT_ID ,
oel.ORIG_SYS_LINE_REF   ,
oel.SOURCE_DOCUMENT_LINE_ID ,
oel.REFERENCE_LINE_ID  ,
oel.REFERENCE_HEADER_ID ,
oel.ACTUAL_SHIPMENT_DATE ,
oel.ACTUAL_ARRIVAL_DATE   ,
oel.EARLIEST_ACCEPTABLE_DATE ,
oel.LATEST_ACCEPTABLE_DATE    ,
oel.SCHEDULE_ARRIVAL_DATE      ,
oel.SCHEDULE_STATUS_CODE        ,
oel.RETURN_REASON_CODE           ,
oel.SHIPPING_INTERFACED_FLAG   ,
oel.CREDIT_INVOICE_LINE_ID    ,
oel.ORIG_SYS_SHIPMENT_REF  ,
oel.INVOICED_QUANTITY     ,
oel.REFERENCE_CUSTOMER_TRX_LINE_ID ,
oel.FULFILLMENT_DATE ,
oel.ACCOUNTING_RULE_DURATION ,
oel.END_CUSTOMER_ID   ,
oel.END_CUSTOMER_CONTACT_ID ,
oel.END_CUSTOMER_SITE_USE_ID ,
oel.SERVICE_CREDIT_ELIGIBLE_CODE ,
oel.ACTUAL_FULFILLMENT_DATE  ,
oel.CONTINGENCY_ID ,
oel.REVREC_EVENT_CODE ,
oel.REVREC_EXPIRATION_DAYS ,
oel.SALESREP_ID ,
oel.CREATION_DATE ,
oel.LAST_UPDATE_DATE ,
oel.TOP_MODEL_LINE_ID ,
oel.LINK_TO_LINE_ID   ,
oel.COMPONENT_NUMBER  ,
oel.OPTION_NUMBER    ,
oel.ATO_LINE_ID     ,
oel.COMPONENT_CODE  ,
PL.NAME PRICE_LIST,
oel.PRICE_LIST_ID     ,
oel.DEMAND_CLASS_CODE  ,
oel.BLANKET_NUMBER ,
oel.SHIP_FROM_ORG_ID ,
oel.SHIP_TO_ORG_ID,
oel.CONTEXT      ,
oel.ATTRIBUTE1    ,
oel.ATTRIBUTE2  ,
oel.ATTRIBUTE3  ,
oel.ATTRIBUTE4  ,
oel.ATTRIBUTE5  ,
oel.ATTRIBUTE6  ,
oel.ATTRIBUTE7  ,
oel.ATTRIBUTE8  ,
oel.ATTRIBUTE9  ,
oel.ATTRIBUTE10 ,
oel.ATTRIBUTE11 ,
oel.ATTRIBUTE12 ,
oel.ATTRIBUTE13 ,
oel.ATTRIBUTE14 ,
oel.ATTRIBUTE15 ,
oel.ATTRIBUTE16 ,
oel.ATTRIBUTE17 ,
oel.ATTRIBUTE18 ,
oel.ATTRIBUTE19 ,
oel.ATTRIBUTE20 ,
oel.open_flag  ,
oel.service_start_date rule_start_date ,
oel.service_end_date   rule_end_date  ,
OEL.line_category_code ,
Decode(Nvl(oel.reference_line_id,-99),-99,NULL,Nvl(OTTA.accounting_credit_method_code,'LIFO'))  REVENUE_REVERSAL_METHOD,
NULL LAST_PERIOD_TO_CREDIT
FROM OE_ORDER_LINES_all oel,
   OE_TRANSACTION_TYPES_TL LT,
QP_LIST_HEADERS_TL PL  ,
OE_TRANSACTION_TYPES_ALL OTTA
where  oel.booked_flag = 'Y'
AND oel.LINE_TYPE_ID = LT.TRANSACTION_TYPE_ID
AND LT.LANGUAGE = (select  LANGUAGE_CODE from fnd_languages where INSTALLED_FLag='B')
AND oel.PRICE_LIST_ID = PL.LIST_HEADER_ID (+)
AND PL.LANGUAGE = (select  LANGUAGE_CODE from fnd_languages where INSTALLED_FLag='B')
AND ITEM_TYPE_CODE <> 'SERVICE'
AND OTTA.TRANSACTION_TYPE_ID=LT.TRANSACTION_TYPE_ID

View Text - HTML Formatted

SELECT OEL.LINE_ID
, OEL.HEADER_ID
, 'SALES_ORDER' DOCUMENT_TYPE_CODE
, OEL.ORG_ID
, OEL.LINE_NUMBER
, LT.NAME LINE_TYPE
, OEL.FLOW_STATUS_CODE
, OEL.INVENTORY_ITEM_ID
, OEL.ORDERED_ITEM
, OEL.ORDER_QUANTITY_UOM
, DECODE (OEL.LINE_CATEGORY_CODE
, 'ORDER'
, OEL.ORDERED_QUANTITY
, 'RETURN'
, -1*OEL.ORDERED_QUANTITY
, OEL.ORDERED_QUANTITY) ORDERED_QUANTITY
, OEL.UNIT_SELLING_PRICE
, OEL.UNIT_LIST_PRICE
, OEL.UNIT_SELLING_PERCENT
, OEL.UNIT_LIST_PERCENT
, OEL.UNIT_PERCENT_BASE_PRICE
, DECODE (OEL.LINE_CATEGORY_CODE
, 'ORDER'
, OEL.UNIT_SELLING_PRICE * OEL.ORDERED_QUANTITY
, 'RETURN'
, -1*OEL.UNIT_SELLING_PRICE * OEL.ORDERED_QUANTITY
, OEL.UNIT_SELLING_PRICE * OEL.ORDERED_QUANTITY) LINE_AMOUNT
, OEL.SCHEDULE_SHIP_DATE
, OEL.CANCELLED_QUANTITY
, OEL.SHIPPED_QUANTITY
, OEL.FULFILLED_QUANTITY
, OEL.SHIPPING_QUANTITY
, OEL.SHIPPING_QUANTITY_UOM
, NULL INVOICABLE_FLAG
, NULL SHIPPABLE_FLAG
, DECODE(NVL(OEL.SHIPPED_QUANTITY
, 0)
, 0
, 'N'
, 'Y') SHIPPED_FLAG
, DECODE(NVL(OEL.INVOICED_QUANTITY
, 0)
, 0
, 'N'
, 'Y') INVOICED_FLAG
, OEL.DELIVERY_LEAD_TIME
, OEL.INVOICE_TO_ORG_ID
, OEL.CUST_PO_NUMBER
, OEL.PROJECT_ID
, OEL.TASK_ID
, OEL.INVOICE_INTERFACE_STATUS_CODE
, OEL.FULFILLED_FLAG
, OEL.CANCELLED_FLAG
, OEL.SHIPMENT_NUMBER
, OEL.SHIPMENT_PRIORITY_CODE
, OEL.SHIPPING_METHOD_CODE
, OEL.FREIGHT_CARRIER_CODE
, OEL.FREIGHT_TERMS_CODE
, OEL.FOB_POINT_CODE
, OEL.PAYMENT_TERM_ID
, OEL.ACCOUNTING_RULE_ID
, OEL.SOURCE_DOCUMENT_TYPE_ID
, OEL.ORIG_SYS_DOCUMENT_REF
, OEL.SOURCE_DOCUMENT_ID
, OEL.ORIG_SYS_LINE_REF
, OEL.SOURCE_DOCUMENT_LINE_ID
, OEL.REFERENCE_LINE_ID
, OEL.REFERENCE_HEADER_ID
, OEL.ACTUAL_SHIPMENT_DATE
, OEL.ACTUAL_ARRIVAL_DATE
, OEL.EARLIEST_ACCEPTABLE_DATE
, OEL.LATEST_ACCEPTABLE_DATE
, OEL.SCHEDULE_ARRIVAL_DATE
, OEL.SCHEDULE_STATUS_CODE
, OEL.RETURN_REASON_CODE
, OEL.SHIPPING_INTERFACED_FLAG
, OEL.CREDIT_INVOICE_LINE_ID
, OEL.ORIG_SYS_SHIPMENT_REF
, OEL.INVOICED_QUANTITY
, OEL.REFERENCE_CUSTOMER_TRX_LINE_ID
, OEL.FULFILLMENT_DATE
, OEL.ACCOUNTING_RULE_DURATION
, OEL.END_CUSTOMER_ID
, OEL.END_CUSTOMER_CONTACT_ID
, OEL.END_CUSTOMER_SITE_USE_ID
, OEL.SERVICE_CREDIT_ELIGIBLE_CODE
, OEL.ACTUAL_FULFILLMENT_DATE
, OEL.CONTINGENCY_ID
, OEL.REVREC_EVENT_CODE
, OEL.REVREC_EXPIRATION_DAYS
, OEL.SALESREP_ID
, OEL.CREATION_DATE
, OEL.LAST_UPDATE_DATE
, OEL.TOP_MODEL_LINE_ID
, OEL.LINK_TO_LINE_ID
, OEL.COMPONENT_NUMBER
, OEL.OPTION_NUMBER
, OEL.ATO_LINE_ID
, OEL.COMPONENT_CODE
, PL.NAME PRICE_LIST
, OEL.PRICE_LIST_ID
, OEL.DEMAND_CLASS_CODE
, OEL.BLANKET_NUMBER
, OEL.SHIP_FROM_ORG_ID
, OEL.SHIP_TO_ORG_ID
, OEL.CONTEXT
, OEL.ATTRIBUTE1
, OEL.ATTRIBUTE2
, OEL.ATTRIBUTE3
, OEL.ATTRIBUTE4
, OEL.ATTRIBUTE5
, OEL.ATTRIBUTE6
, OEL.ATTRIBUTE7
, OEL.ATTRIBUTE8
, OEL.ATTRIBUTE9
, OEL.ATTRIBUTE10
, OEL.ATTRIBUTE11
, OEL.ATTRIBUTE12
, OEL.ATTRIBUTE13
, OEL.ATTRIBUTE14
, OEL.ATTRIBUTE15
, OEL.ATTRIBUTE16
, OEL.ATTRIBUTE17
, OEL.ATTRIBUTE18
, OEL.ATTRIBUTE19
, OEL.ATTRIBUTE20
, OEL.OPEN_FLAG
, OEL.SERVICE_START_DATE RULE_START_DATE
, OEL.SERVICE_END_DATE RULE_END_DATE
, OEL.LINE_CATEGORY_CODE
, DECODE(NVL(OEL.REFERENCE_LINE_ID
, -99)
, -99
, NULL
, NVL(OTTA.ACCOUNTING_CREDIT_METHOD_CODE
, 'LIFO')) REVENUE_REVERSAL_METHOD
, NULL LAST_PERIOD_TO_CREDIT FROM OE_ORDER_LINES_ALL OEL
, OE_TRANSACTION_TYPES_TL LT
, QP_LIST_HEADERS_TL PL
, OE_TRANSACTION_TYPES_ALL OTTA WHERE OEL.BOOKED_FLAG = 'Y' AND OEL.LINE_TYPE_ID = LT.TRANSACTION_TYPE_ID AND LT.LANGUAGE = (SELECT LANGUAGE_CODE
FROM FND_LANGUAGES
WHERE INSTALLED_FLAG='B') AND OEL.PRICE_LIST_ID = PL.LIST_HEADER_ID (+) AND PL.LANGUAGE = (SELECT LANGUAGE_CODE
FROM FND_LANGUAGES
WHERE INSTALLED_FLAG='B') AND ITEM_TYPE_CODE <> 'SERVICE' AND OTTA.TRANSACTION_TYPE_ID=LT.TRANSACTION_TYPE_ID