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: ViewONT.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 Mandatory 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:

SchemaAPPS
SynonymFINANCIALS_SYSTEM_PARAMS_ALL
ViewGL_SETS_OF_BOOKS
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_LOCATIONS
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymOE_DROP_SHIP_SOURCES
ViewOE_LOOKUPS
SynonymOE_ORDER_LINES_ALL
ViewPER_PEOPLE_F
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_RELEASES_ALL
SynonymPO_REQUISITION_HEADERS_ALL
SynonymPO_REQUISITION_LINES_ALL
ViewPO_VENDORS

APPS.OE_DROP_SHIP_LINKS_V is not referenced by any database object