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

VIEW: APPS.POR_RCV_SHIP_DISP_HEADERS_V

Object Details
Object Name: POR_RCV_SHIP_DISP_HEADERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewICX.POR_RCV_SHIP_DISP_HEADERS_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_HEADERS_V view queries the information which is used to display the shipment header level information on the Shipment Details page.


[View Source]

Columns
Name Datatype Length Mandatory Comments
SHIPPED_DATE DATE

Shipped date
EXPECTED_RECEIPT_DATE DATE

Expected receipt date
FREIGHT_TERM VARCHAR2 (25)
Freight terms
FREIGHT_CARRIER_CODE VARCHAR2 (25)
Freight carrier code
NUM_OF_CONTAINER NUMBER

Number of containers
WAYBILL_AIRBILL_NUM VARCHAR2 (30)
Waybill/Airbill number
PACKAGING_CODE VARCHAR2 (5)
Packaging code
SHIPMENT_NUM VARCHAR2 (30)
Shipment number
SHIP_HEADER_ID NUMBER

Shipment header id
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 SHIPPED_DATE
,      EXPECTED_RECEIPT_DATE
,      FREIGHT_TERM
,      FREIGHT_CARRIER_CODE
,      NUM_OF_CONTAINER
,      WAYBILL_AIRBILL_NUM
,      PACKAGING_CODE
,      SHIPMENT_NUM
,      SHIP_HEADER_ID
,      ORDER_TYPE
,      LINE_ID
FROM APPS.POR_RCV_SHIP_DISP_HEADERS_V;

Dependencies

[top of page]

APPS.POR_RCV_SHIP_DISP_HEADERS_V references the following:

SchemaAPPS
PL/SQL PackagePO_CLM_INTG_GRP - show dependent code
ViewPO_LINE_LOCATIONS_TRX_V
SynonymPO_REQUISITION_LINES
SynonymRCV_SHIPMENT_HEADERS
SynonymRCV_SHIPMENT_LINES

APPS.POR_RCV_SHIP_DISP_HEADERS_V is not referenced by any database object