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

Object Details

Object Name:	POR_RCV_SHIP_DISP_LINES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	ICX.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	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:

APPS: FND_TERRITORIES_VL; HR_LOCATIONS_ALL_TL; PO_CLM_INTG_GRP - show dependent code; PO_HEADERS; PO_INQ_SV - show dependent code; PO_LINES_TRX_V; PO_LINE_LOCATIONS_TRX_V; PO_REQUISITION_LINES; RCV_SHIPMENT_LINES

APPS.POR_RCV_SHIP_DISP_LINES_V is not referenced by any database object