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

VIEW: APPS.POR_RCV_SHIP_DISP_LINES_V

Object Details
Object Name: POR_RCV_SHIP_DISP_LINES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewICX.POR_RCV_SHIP_DISP_LINES_V
Subobject Name:
Status: VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


The POR_RCV_SHIP_DISP_LINES_V view queries the information which is used to display the shipment line level information on the Shipment Details page.


[View Source]

Columns
Name Datatype Length Mandatory Comments
LINE_NUM NUMBER

Shipment line number
SHIP_HEADER_ID NUMBER

Shipment header id
ORDER_NUMBER VARCHAR2 (4000)
PO number in case of Purchase Order and Sales Order number in case of Sales Order
ITEM_DESCRIPTION VARCHAR2 (240)
Item description for the shipment line
SUPPLIER_ITEM_NUMBER VARCHAR2 (25)
Supplier item number
SHIP_TO_LOCATION VARCHAR2 (60)
Ship to location
QUANTITY_SHIPPED NUMBER

Quantity shipped
PACKING_SLIP VARCHAR2 (25)
Packing slip number
CONTAINER_NUM VARCHAR2 (35)
Container number
COUNTRY_OF_ORIGIN_CODE VARCHAR2 (30)
Country of origin code
COMMENTS VARCHAR2 (4000)
Comments
ORDER_TYPE VARCHAR2 (3)
Order type (PO / REQ)
LINE_ID NUMBER

Requisition line id or PO line location id
Query Text

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


SELECT LINE_NUM
,      SHIP_HEADER_ID
,      ORDER_NUMBER
,      ITEM_DESCRIPTION
,      SUPPLIER_ITEM_NUMBER
,      SHIP_TO_LOCATION
,      QUANTITY_SHIPPED
,      PACKING_SLIP
,      CONTAINER_NUM
,      COUNTRY_OF_ORIGIN_CODE
,      COMMENTS
,      ORDER_TYPE
,      LINE_ID
FROM APPS.POR_RCV_SHIP_DISP_LINES_V;

Dependencies

[top of page]

APPS.POR_RCV_SHIP_DISP_LINES_V references the following:

SchemaAPPS
ViewFND_TERRITORIES_VL
SynonymHR_LOCATIONS_ALL_TL
SynonymPO_HEADERS
PL/SQL PackagePO_INQ_SV - show dependent code
SynonymPO_LINES
SynonymPO_LINE_LOCATIONS
SynonymPO_REQUISITION_LINES
SynonymRCV_SHIPMENT_LINES

APPS.POR_RCV_SHIP_DISP_LINES_V is not referenced by any database object