[Home] [Help] [Dependency Information]
Object Name: | OEBV_ORDER_LINES |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ONT.OEBV_ORDER_LINES |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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) |
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;
APPS.OEBV_ORDER_LINES is not referenced by any database object
|
|
|