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_DROP_SHIP_LINKS_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

This view contains data from PO tables such are Purchase Order Number and Purchase Requisition Number. For externally sourced lines, the user can view this information from the sales orders form.

[View Source]

Columns

Name	Datatype	Length	Comments
LINE_ID	NUMBER		Order line identifier.
TYPE_LOOKUP_CODE	VARCHAR2	(25)	Requisition Type Code
TYPE	NUMBER		Requisition Type
DOCUMENT_TYPE	VARCHAR2	(80)	Document Type
PO_REQ_HEADER_ID	NUMBER		Requisition Header ID
PO_REQ_NUMBER	VARCHAR2	(20)	Requisition Number
REVISION_NUM	NUMBER		Revision Number
RELEASE_NUM	NUMBER		Release Number
LINE_NUM	NUMBER		Requisition Line Number
BUYER_NAME	VARCHAR2	(240)	Buyer
VENDOR_NAME	VARCHAR2	(240)	Vendor
STATUS	VARCHAR2	(25)	Approved/Pending
CREATION_DATE	DATE		Standard Who column
SUPPLIER_ITEM	VARCHAR2	(25)	Supplier Item Description
ORDERED_UOM	VARCHAR2	(25)	Unit of Measurement
QUANTITY	NUMBER		Quantity
CURRENCY_CODE	VARCHAR2	(15)	Currency
UNIT_PRICE	NUMBER		Unit Price
LOCATION_CODE	VARCHAR2	(60)	Destination Location Code
SCHEDULE_DATE	DATE		Date Scheduled
RECEIVED_UOM	VARCHAR2	(25)	Unit of Measurement
QUANTITY_RECEIVED	NUMBER		Received Quantity
SHIPMENT_NUMBER	NUMBER		Shipment Number
PROMISED_DATE	DATE		Date Promised
ORG_ID	NUMBER		Organization Identifier
SECONDARY_UNIT_OF_MEASURE	VARCHAR2	(25)	Secondary Unit Of Measure
SECONDARY_QUANTITY	NUMBER		Secondary Quantity
SECONDARY_QUANTITY_RECEIVED	NUMBER		Secondary Quantity Received
PREFERRED_GRADE	VARCHAR2	(150)	Preferred Grade

Query Text

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


SELECT LINE_ID
,      TYPE_LOOKUP_CODE
,      TYPE
,      DOCUMENT_TYPE
,      PO_REQ_HEADER_ID
,      PO_REQ_NUMBER
,      REVISION_NUM
,      RELEASE_NUM
,      LINE_NUM
,      BUYER_NAME
,      VENDOR_NAME
,      STATUS
,      CREATION_DATE
,      SUPPLIER_ITEM
,      ORDERED_UOM
,      QUANTITY
,      CURRENCY_CODE
,      UNIT_PRICE
,      LOCATION_CODE
,      SCHEDULE_DATE
,      RECEIVED_UOM
,      QUANTITY_RECEIVED
,      SHIPMENT_NUMBER
,      PROMISED_DATE
,      ORG_ID
,      SECONDARY_UNIT_OF_MEASURE
,      SECONDARY_QUANTITY
,      SECONDARY_QUANTITY_RECEIVED
,      PREFERRED_GRADE
FROM APPS.OE_DROP_SHIP_LINKS_V;

Dependencies

[top of page]

APPS.OE_DROP_SHIP_LINKS_V references the following:

APPS: FINANCIALS_SYSTEM_PARAMS_ALL; GL_SETS_OF_BOOKS; HR_GENERAL - show dependent code; HR_LOCATIONS; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; OE_DROP_SHIP_SOURCES; OE_LOOKUPS; OE_ORDER_LINES_ALL; PER_PEOPLE_F; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; PO_RELEASES_ALL; PO_REQUISITION_HEADERS_ALL; PO_REQUISITION_LINES_ALL; PO_VENDORS

APPS.OE_DROP_SHIP_LINKS_V is not referenced by any database object