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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.OEBV_ORDER_LINES

Object Details

Object Name:	OEBV_ORDER_LINES
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ONT.OEBV_ORDER_LINES
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LINE_NUMBER	NUMBER		Yes
ORDERED_QUANTITY	NUMBER
ORDERED_QUANTITY_UOM	VARCHAR2	(3)
INVOICED_QUANTITY	NUMBER
UNIT_SELLING_PRICE	NUMBER
REQUEST_DATE	DATE
SCHEDULE_SHIP_DATE	DATE
SCHEDULE_STATUS	VARCHAR2	(30)
CANCELLED_QUANTITY	NUMBER
TAX_CODE	VARCHAR2	(50)
FULFILLMENT_DATE	DATE
UNIT_LIST_PRICE	NUMBER
_LA:CALCULATE_PRICE_FLAG	CHAR	(69)
PRICING_QUANTITY	NUMBER
PRICING_QUANTITY_UOM	VARCHAR2	(3)
PRICING_DATE	DATE
PROMISE_DATE	DATE
CUSTOMER_NUMBER	NUMBER
TAX_VALUE	NUMBER
_LA:SOURCE_TYPE	CHAR	(56)
_LA:SHIPMENT_PRIORITY	CHAR	(68)
_LA:FREIGHT_TERMS	CHAR	(60)
_LA:BOOKED_FLAG	CHAR	(46)
_LA:CANCELLED_FLAG	CHAR	(49)
_LA:OPEN_FLAG	CHAR	(44)
ACTUAL_SHIPMENT_DATE	DATE
_LA:SHIPPABLE_FLAG	CHAR	(49)
SHIPPED_QUANTITY	NUMBER
_LA:FULFILLED_FLAG	CHAR	(49)
ITEM_TYPE_CODE	VARCHAR2	(30)
FULFILLED_QUANTITY	NUMBER
LINE_CATEGORY_CODE	VARCHAR2	(30)	Yes
ORG_ID	NUMBER
CUSTOMER_ID	NUMBER
LINE_ID	NUMBER		Yes
HEADER_ID	NUMBER		Yes
SHIP_FROM_ORG_ID	NUMBER
ORDERED_ITEM_ID	NUMBER		Yes
COMMITMENT_ID	NUMBER
LINE_TYPE_ID	NUMBER		Yes
SALESREP_ID	NUMBER	(15)
PRICE_LIST_ID	NUMBER
AGREEMENT_ID	NUMBER
_DF:PRICING	CHAR	(38)
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
ORIGINAL_LIST_PRICE	NUMBER
ORDER_SOURCE_ID	NUMBER
CHARGE_PERIODICITY_CODE	VARCHAR2	(3)		This column is used to determine the price for an order line with a recurring charge item
END_CUSTOMER_ID	NUMBER			End Customer Id
END_CUSTOMER_CONTACT_ID	NUMBER			End Customer Contact Id
END_CUSTOMER_SITE_USE_ID	NUMBER			End Customer Site Use Id
_LA:IB_OWNER	CHAR	(47)		Ib Owner
_LA:IB_CURRENT_LOCATION	CHAR	(69)		Ib Current Location
_LA:IB_INSTALLED_AT_LOCATION	CHAR	(74)		Ib Installed At Location
CONTINGENCY_ID	NUMBER
REVREC_EVENT_CODE	VARCHAR2	(30)
REVREC_EXPIRATION_DAYS	NUMBER
ACCEPTED_QUANTITY	NUMBER
ACCEPTED_BY	NUMBER
REVREC_COMMENTS	VARCHAR2	(2000)
REVREC_REFERENCE_DOCUMENT	VARCHAR2	(240)
REVREC_SIGNATURE	VARCHAR2	(240)
REVREC_SIGNATURE_DATE	DATE
REVREC_IMPLICIT_FLAG	VARCHAR2	(1)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
FROM APPS.OEBV_ORDER_LINES;

Dependencies

[top of page]

APPS.OEBV_ORDER_LINES references the following:

APPS: OE_ORDER_LINES

APPS.OEBV_ORDER_LINES is not referenced by any database object