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

VIEW: APPS.WSH_NEW_DELIVERIES2_DFV

Object Details
Object Name: WSH_NEW_DELIVERIES2_DFV
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
CONTEXT_VALUE VARCHAR2 (30)
VOLUME_TYPE VARCHAR2 (150)
VOLUME_NUMBER VARCHAR2 (150)
VOLUME_QUANTITY NUMBER

VEHICLE_PLATE_STATE_CODE VARCHAR2 (150)
VEHICLE_ANTT_INSCRIPTION VARCHAR2 (150)
TOWING_VEHICLE_PLATE1 VARCHAR2 (150)
TOWING_VEH_PLATE_STATE_CODE1 VARCHAR2 (150)
TOWING_VEHICLE_PLATE2 VARCHAR2 (150)
TOWING_VEH_PLATE_STATE_CODE2 VARCHAR2 (150)
TOWING_VEHICLE_PLATE VARCHAR2 (150)
TOWING_VEH_PLATE_STATE_CODE3 VARCHAR2 (150)
TOWING_VEHICLE_PLATE4 VARCHAR2 (150)
TOWING_VEH_PLATE_STATE_CODE4 VARCHAR2 (150)
TOWING_VEHICLE_PLATE5 VARCHAR2 (150)
TOWING_VEH_PLATE_STATE_CODE5 VARCHAR2 (150)
TOWING_VEH_ANTT_INSCRIPTION VARCHAR2 (150)
SEAL_NUMBER VARCHAR2 (150)
WAGON_CODE VARCHAR2 (150)
FERRY_CODE VARCHAR2 (150)
CONCATENATED_SEGMENTS VARCHAR2 (2899)
Query Text

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


SELECT ROW_ID
,      CONTEXT_VALUE
,      VOLUME_TYPE
,      VOLUME_NUMBER
,      VOLUME_QUANTITY
,      VEHICLE_PLATE_STATE_CODE
,      VEHICLE_ANTT_INSCRIPTION
,      TOWING_VEHICLE_PLATE1
,      TOWING_VEH_PLATE_STATE_CODE1
,      TOWING_VEHICLE_PLATE2
,      TOWING_VEH_PLATE_STATE_CODE2
,      TOWING_VEHICLE_PLATE
,      TOWING_VEH_PLATE_STATE_CODE3
,      TOWING_VEHICLE_PLATE4
,      TOWING_VEH_PLATE_STATE_CODE4
,      TOWING_VEHICLE_PLATE5
,      TOWING_VEH_PLATE_STATE_CODE5
,      TOWING_VEH_ANTT_INSCRIPTION
,      SEAL_NUMBER
,      WAGON_CODE
,      FERRY_CODE
,      CONCATENATED_SEGMENTS
FROM APPS.WSH_NEW_DELIVERIES2_DFV;

Dependencies

[top of page]

APPS.WSH_NEW_DELIVERIES2_DFV references the following:

SchemaAPPS
PL/SQL PackageFND_NUMBER - show dependent code
SynonymWSH_NEW_DELIVERIES

APPS.WSH_NEW_DELIVERIES2_DFV is not referenced by any database object