View: OE_ORDER_LINES_RM_V

Product:	ONT - Order Management
Description:
Implementation/DBA Data:	APPS.OE_ORDER_LINES_RM_V

View Text

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