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.

[Home] [Help]

View: OEBV_ORDER_LINES

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

View Text

SELECT LINE.LINE_NUMBER
, LINE.ORDERED_QUANTITY
, LINE.ORDER_QUANTITY_UOM
, LINE.INVOICED_QUANTITY
, LINE.UNIT_SELLING_PRICE
, LINE.REQUEST_DATE
, LINE.SCHEDULE_SHIP_DATE
, LINE.SCHEDULE_STATUS_CODE
, LINE.CANCELLED_QUANTITY
, LINE.TAX_CODE
, LINE.FULFILLMENT_DATE
, LINE.UNIT_LIST_PRICE
, '_LA:LINE.CALCULATE_PRICE_FLAG:OE_LOOKUPS:CALCULATE_PRICE_FLAG:MEANING'
, LINE.PRICING_QUANTITY
, LINE.PRICING_QUANTITY_UOM
, LINE.PRICING_DATE
, LINE.PROMISE_DATE
, LINE.SOLD_TO_ORG_ID
, LINE.TAX_VALUE
, '_LA:LINE.SOURCE_TYPE_CODE:OE_LOOKUPS:SOURCE_TYPE:MEANING'
, '_LA:LINE.SHIPMENT_PRIORITY_CODE:OE_LOOKUPS:SHIPMENT_PRIORITY:MEANING'
, '_LA:LINE.FREIGHT_TERMS_CODE:OE_LOOKUPS:FREIGHT_TERMS:MEANING'
, '_LA:LINE.BOOKED_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, '_LA:LINE.CANCELLED_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, '_LA:LINE.OPEN_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, LINE.ACTUAL_SHIPMENT_DATE
, '_LA:LINE.SHIPPABLE_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, LINE.SHIPPED_QUANTITY
, '_LA:LINE.FULFILLED_FLAG:OE_LOOKUPS:YES_NO:MEANING'
, LINE.ITEM_TYPE_CODE
, LINE.FULFILLED_QUANTITY
, LINE.LINE_CATEGORY_CODE
, LINE.ORG_ID
, LINE.SOLD_TO_ORG_ID
, LINE.LINE_ID
, LINE.HEADER_ID
, LINE.SHIP_FROM_ORG_ID
, LINE.INVENTORY_ITEM_ID
, LINE.COMMITMENT_ID
, LINE.LINE_TYPE_ID
, LINE.SALESREP_ID
, LINE.PRICE_LIST_ID
, LINE.AGREEMENT_ID
, '_DF:ONT:OE_LINE_PRICING_ATTRIBUTE:LINE'
, LINE.LAST_UPDATE_DATE
, LINE.LAST_UPDATED_BY
, LINE.CREATION_DATE
, LINE.CREATED_BY
, LINE.ORIGINAL_LIST_PRICE
, LINE.ORDER_SOURCE_ID
, LINE.CHARGE_PERIODICITY_CODE
, LINE.END_CUSTOMER_ID
, LINE.END_CUSTOMER_CONTACT_ID
, LINE.END_CUSTOMER_SITE_USE_ID
, '_LA:LINE.IB_OWNER:OE_LOOKUPS:ITEM_OWNER:MEANING'
, '_LA:LINE.IB_CURRENT_LOCATION:OE_LOOKUPS:ITEM_CURRENT_LOCATION:MEANING'
, '_LA:LINE.IB_INSTALLED_AT_LOCATION:OE_LOOKUPS:ITEM_INSTALL_LOCATION:MEANING'
, LINE.CONTINGENCY_ID
, LINE.REVREC_EVENT_CODE
, LINE.REVREC_EXPIRATION_DAYS
, LINE.ACCEPTED_QUANTITY
, LINE.ACCEPTED_BY
, LINE.REVREC_COMMENTS
, LINE.REVREC_REFERENCE_DOCUMENT
, LINE.REVREC_SIGNATURE
, LINE.REVREC_SIGNATURE_DATE
, LINE.REVREC_IMPLICIT_FLAG
FROM OE_ORDER_LINES LINE
WHERE '_SEC:LINE.SHIP_FROM_ORG_ID' IS NOT NULL

Columns

Name
LINE_NUMBER
ORDERED_QUANTITY
ORDERED_QUANTITY_UOM
INVOICED_QUANTITY
UNIT_SELLING_PRICE
REQUEST_DATE
SCHEDULE_SHIP_DATE
SCHEDULE_STATUS
CANCELLED_QUANTITY
TAX_CODE
FULFILLMENT_DATE
UNIT_LIST_PRICE
"_LA:CALCULATE_PRICE_FLAG"
PRICING_QUANTITY
PRICING_QUANTITY_UOM
PRICING_DATE
PROMISE_DATE
CUSTOMER_NUMBER
TAX_VALUE
"_LA:SOURCE_TYPE"
"_LA:SHIPMENT_PRIORITY"
"_LA:FREIGHT_TERMS"
"_LA:BOOKED_FLAG"
"_LA:CANCELLED_FLAG"
"_LA:OPEN_FLAG"
ACTUAL_SHIPMENT_DATE
"_LA:SHIPPABLE_FLAG"
SHIPPED_QUANTITY
"_LA:FULFILLED_FLAG"
ITEM_TYPE_CODE
FULFILLED_QUANTITY
LINE_CATEGORY_CODE
ORG_ID
CUSTOMER_ID
LINE_ID
HEADER_ID
SHIP_FROM_ORG_ID
ORDERED_ITEM_ID
COMMITMENT_ID
LINE_TYPE_ID
SALESREP_ID
PRICE_LIST_ID
AGREEMENT_ID
"_DF:PRICING"
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
ORIGINAL_LIST_PRICE
ORDER_SOURCE_ID
CHARGE_PERIODICITY_CODE
END_CUSTOMER_ID
END_CUSTOMER_CONTACT_ID
END_CUSTOMER_SITE_USE_ID
"_LA:IB_OWNER"
"_LA:IB_CURRENT_LOCATION"
"_LA:IB_INSTALLED_AT_LOCATION"
CONTINGENCY_ID
REVREC_EVENT_CODE
REVREC_EXPIRATION_DAYS
ACCEPTED_QUANTITY
ACCEPTED_BY
REVREC_COMMENTS
REVREC_REFERENCE_DOCUMENT
REVREC_SIGNATURE
REVREC_SIGNATURE_DATE
REVREC_IMPLICIT_FLAG