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.OE_DELIVERY_LINES_V

Object Details

Object Name:	OE_DELIVERY_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ONT.OE_DELIVERY_LINES_V
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
HEADER_ID	NUMBER		Yes
HEADER_NUMBER	NUMBER		Yes
HEADER_TYPE_ID	NUMBER		Yes
HEADER_TYPE_NAME	VARCHAR2	(30)	Yes
LINE_ID	NUMBER		Yes
LINE_NUMBER	VARCHAR2	(204)
ORG_ID	NUMBER
SOLD_TO_ORG_ID	NUMBER
INVENTORY_ITEM_ID	NUMBER		Yes
ITEM_DESCRIPTION	VARCHAR2	(240)
SHIP_FROM_ORG_ID	NUMBER
SUBINVENTORY	VARCHAR2	(10)
SHIP_TO_ORG_ID	NUMBER
DELIVER_TO_ORG_ID	NUMBER
SHIP_TO_CONTACT_ID	NUMBER
DELIVER_TO_CONTACT_ID	NUMBER
INTMED_SHIP_TO_ORG_ID	NUMBER
INTMED_SHIP_TO_CONTACT_ID	NUMBER
SHIP_TOLERANCE_ABOVE	NUMBER
SHIP_TOLERANCE_BELOW	NUMBER
ORDERED_QUANTITY	NUMBER
SHIPPED_QUANTITY	NUMBER
DELIVERED_QUANTITY	NUMBER
ORDER_QUANTITY_UOM	VARCHAR2	(3)
SHIPPING_QUANTITY_UOM	VARCHAR2	(3)
SHIPPING_QUANTITY	NUMBER
DATE_SCHEDULED	DATE
SHIPPING_METHOD_CODE	VARCHAR2	(30)
FREIGHT_CARRIER_CODE	VARCHAR2	(30)
FREIGHT_TERMS_CODE	VARCHAR2	(30)
SHIPMENT_PRIORITY_CODE	VARCHAR2	(30)
FOB_CODE	VARCHAR2	(30)
ITEM_IDENTIFIER_TYPE	VARCHAR2	(30)
ORDERED_ITEM_ID	NUMBER
DATE_REQUESTED	DATE
DEP_PLAN_REQUIRED_FLAG	VARCHAR2	(1)
CUSTOMER_PROD_SEQ_NUMBER	VARCHAR2	(50)
CUSTOMER_DOCK_CODE	VARCHAR2	(50)
SHIPPING_INTERFACED_FLAG	VARCHAR2	(1)
SHIP_SET_ID	NUMBER
ATO_LINE_ID	NUMBER
SHIP_MODEL_COMPLETE_FLAG	VARCHAR2	(1)
TOP_MODEL_LINE_ID	NUMBER
ITEM_TYPE_CODE	VARCHAR2	(30)
CUST_PO_NUMBER	VARCHAR2	(50)
ARRIVAL_SET_ID	NUMBER
LINE_CATEGORY_CODE	VARCHAR2	(30)	Yes
SOURCE_TYPE_CODE	VARCHAR2	(30)
LINE_TYPE_ID	NUMBER		Yes
PROJECT_ID	NUMBER
TASK_ID	NUMBER
SHIPPING_INSTRUCTIONS	VARCHAR2	(2000)
PACKING_INSTRUCTIONS	VARCHAR2	(2000)
MASTER_CONTAINER_ITEM_ID	NUMBER
DETAIL_CONTAINER_ITEM_ID	NUMBER
PREFERRED_GRADE	VARCHAR2	(150)
ORDERED_QUANTITY2	NUMBER
ORDERED_QUANTITY_UOM2	VARCHAR2	(3)
UNIT_LIST_PRICE	NUMBER
TRANSACTIONAL_CURR_CODE	VARCHAR2	(15)
END_ITEM_UNIT_NUMBER	VARCHAR2	(30)
TP_CONTEXT	VARCHAR2	(30)		Descriptive Flexfield segment
TP_ATTRIBUTE1	VARCHAR2	(240)		Descriptive Flexfield segment
TP_ATTRIBUTE2	VARCHAR2	(240)		Descriptive Flexfield segment
TP_ATTRIBUTE3	VARCHAR2	(240)		Descriptive Flexfield segment
TP_ATTRIBUTE4	VARCHAR2	(240)		Descriptive Flexfield segment
TP_ATTRIBUTE5	VARCHAR2	(240)		Descriptive Flexfield segment
TP_ATTRIBUTE6	VARCHAR2	(240)		Descriptive Flexfield segment
TP_ATTRIBUTE7	VARCHAR2	(240)		Descriptive Flexfield segment
TP_ATTRIBUTE8	VARCHAR2	(240)		Descriptive Flexfield segment
TP_ATTRIBUTE9	VARCHAR2	(240)		Descriptive Flexfield segment
TP_ATTRIBUTE10	VARCHAR2	(240)		Descriptive Flexfield segment
TP_ATTRIBUTE11	VARCHAR2	(240)		Descriptive Flexfield segment
TP_ATTRIBUTE12	VARCHAR2	(240)		Descriptive Flexfield segment
TP_ATTRIBUTE13	VARCHAR2	(240)		Descriptive Flexfield segment
TP_ATTRIBUTE14	VARCHAR2	(240)		Descriptive Flexfield segment
TP_ATTRIBUTE15	VARCHAR2	(240)		Descriptive Flexfield segment
SOLD_TO_CONTACT_ID	NUMBER
CUSTOMER_JOB	VARCHAR2	(50)
CUSTOMER_PRODUCTION_LINE	VARCHAR2	(50)
CUST_MODEL_SERIAL_NUMBER	VARCHAR2	(50)
LINE_SET_ID	NUMBER
SOURCE_DOCUMENT_TYPE_ID	NUMBER
ORDER_DATE_TYPE_CODE	VARCHAR2	(30)
SCHEDULE_ARRIVAL_DATE	DATE
PROMISE_DATE	DATE
EARLIEST_ACCEPTABLE_DATE	DATE
LATEST_ACCEPTABLE_DATE	DATE
EARLIEST_SHIP_DATE	DATE

Query Text

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


SELECT HEADER_ID
,      HEADER_NUMBER
,      HEADER_TYPE_ID
,      HEADER_TYPE_NAME
,      LINE_ID
,      LINE_NUMBER
,      ORG_ID
,      SOLD_TO_ORG_ID
,      INVENTORY_ITEM_ID
,      ITEM_DESCRIPTION
,      SHIP_FROM_ORG_ID
,      SUBINVENTORY
,      SHIP_TO_ORG_ID
,      DELIVER_TO_ORG_ID
,      SHIP_TO_CONTACT_ID
,      DELIVER_TO_CONTACT_ID
,      INTMED_SHIP_TO_ORG_ID
,      INTMED_SHIP_TO_CONTACT_ID
,      SHIP_TOLERANCE_ABOVE
,      SHIP_TOLERANCE_BELOW
,      ORDERED_QUANTITY
,      SHIPPED_QUANTITY
,      DELIVERED_QUANTITY
,      ORDER_QUANTITY_UOM
,      SHIPPING_QUANTITY_UOM
,      SHIPPING_QUANTITY
,      DATE_SCHEDULED
,      SHIPPING_METHOD_CODE
,      FREIGHT_CARRIER_CODE
,      FREIGHT_TERMS_CODE
,      SHIPMENT_PRIORITY_CODE
,      FOB_CODE
,      ITEM_IDENTIFIER_TYPE
,      ORDERED_ITEM_ID
,      DATE_REQUESTED
,      DEP_PLAN_REQUIRED_FLAG
,      CUSTOMER_PROD_SEQ_NUMBER
,      CUSTOMER_DOCK_CODE
,      SHIPPING_INTERFACED_FLAG
,      SHIP_SET_ID
,      ATO_LINE_ID
,      SHIP_MODEL_COMPLETE_FLAG
,      TOP_MODEL_LINE_ID
,      ITEM_TYPE_CODE
,      CUST_PO_NUMBER
,      ARRIVAL_SET_ID
,      LINE_CATEGORY_CODE
,      SOURCE_TYPE_CODE
,      LINE_TYPE_ID
,      PROJECT_ID
,      TASK_ID
,      SHIPPING_INSTRUCTIONS
,      PACKING_INSTRUCTIONS
,      MASTER_CONTAINER_ITEM_ID
,      DETAIL_CONTAINER_ITEM_ID
,      PREFERRED_GRADE
,      ORDERED_QUANTITY2
,      ORDERED_QUANTITY_UOM2
,      UNIT_LIST_PRICE
,      TRANSACTIONAL_CURR_CODE
,      END_ITEM_UNIT_NUMBER
,      TP_CONTEXT
,      TP_ATTRIBUTE1
,      TP_ATTRIBUTE2
,      TP_ATTRIBUTE3
,      TP_ATTRIBUTE4
,      TP_ATTRIBUTE5
,      TP_ATTRIBUTE6
,      TP_ATTRIBUTE7
,      TP_ATTRIBUTE8
,      TP_ATTRIBUTE9
,      TP_ATTRIBUTE10
,      TP_ATTRIBUTE11
,      TP_ATTRIBUTE12
,      TP_ATTRIBUTE13
,      TP_ATTRIBUTE14
,      TP_ATTRIBUTE15
,      SOLD_TO_CONTACT_ID
,      CUSTOMER_JOB
,      CUSTOMER_PRODUCTION_LINE
,      CUST_MODEL_SERIAL_NUMBER
,      LINE_SET_ID
,      SOURCE_DOCUMENT_TYPE_ID
,      ORDER_DATE_TYPE_CODE
,      SCHEDULE_ARRIVAL_DATE
,      PROMISE_DATE
,      EARLIEST_ACCEPTABLE_DATE
,      LATEST_ACCEPTABLE_DATE
,      EARLIEST_SHIP_DATE
FROM APPS.OE_DELIVERY_LINES_V;

Dependencies

[top of page]

APPS.OE_DELIVERY_LINES_V references the following:

APPS: MTL_CUSTOMER_ITEMS; MTL_SYSTEM_ITEMS; OE_ORDER_HEADERS_ALL; OE_ORDER_LINES_ALL; OE_SYS_PARAMETERS - show dependent code; OE_TRANSACTION_TYPES_TL

APPS.OE_DELIVERY_LINES_V is referenced by following:

APPS: WSH_USA_ACTIONS_PVT - show dependent code