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

Object Details

Object Name:	WSHFV_DOCUMENT_PACKSLIP
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WSH.WSHFV_DOCUMENT_PACKSLIP
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DOCUMENT_INSTANCE_ID	NUMBER		Yes	Document Instance Id
ENTITY_NAME	VARCHAR2	(50)	Yes	Entity Name
ENTITY_ID	NUMBER		Yes	Entity Id
_LA:DOCUMENT_TYPE	CHAR	(55)		Lookup - Document Type
SEQUENCE_NUMBER	VARCHAR2	(50)	Yes	Sequence Number
STATUS	VARCHAR2	(30)		Status
FINAL_PRINT_DATE	DATE			Final Print Date
DOC_SEQUENCE_CATEGORY_ID	NUMBER			Document Sequence Category Id
DOCUMENT_CODE	VARCHAR2	(30)		Document Code
_LA:ENABLED_FLAG	CHAR	(47)		Lookup - Enabled Flag
_DF	CHAR	(34)		Descriptive Flexfield
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
LAST_UPDATE_LOGIN	NUMBER
POD_FLAG	VARCHAR2	(1)		POD Flag
POD_BY	VARCHAR2	(150)		POD By
POD_DATE	DATE			POD Date
REASON_OF_TRANSPORT	VARCHAR2	(30)		Reason Of Transport
DESCRIPTION	VARCHAR2	(30)		Description
COD_AMOUNT	NUMBER			COD Amount
COD_CURRENCY_CODE	VARCHAR2	(15)		COD Currency Code
COD_REMIT_TO	VARCHAR2	(150)		COD Remit To
COD_CHARGE_PAID_BY	VARCHAR2	(150)		COD Charge Paid By
PROBLEM_CONTACT_REFERENCE	VARCHAR2	(500)		Problem Contact Reference
BILL_FREIGHT_TO	VARCHAR2	(1000)		Bill Freight To
CARRIED_BY	VARCHAR2	(150)		Carried By
PORT_OF_LOADING	VARCHAR2	(150)		Port Of Loading
PORT_OF_DISCHARGE	VARCHAR2	(150)		Port Of Discharge
BOOKING_OFFICE	VARCHAR2	(50)		Booking Office
BOOKING_NUMBER	VARCHAR2	(30)		Booking Number
SERVICE_CONTRACT	VARCHAR2	(30)		Service Contract
SHIPPER_EXPORT_REF	VARCHAR2	(30)		Shipper Export Ref
CARRIER_EXPORT_REF	VARCHAR2	(30)		Carrier Export Ref
DOC_NOTIFY_PARTY	VARCHAR2	(30)		BOL Notify Party
AETC_NUMBER	VARCHAR2	(30)		AETC Number
SHIPPER_SIGNED_BY	VARCHAR2	(150)		Shipper Signed By
SHIPPER_DATE	DATE			Shipper Date
CARRIER_SIGNED_BY	VARCHAR2	(150)		Carrier Signed By
CARRIER_DATE	DATE			Carrier Date
DOC_ISSUE_OFFICE	VARCHAR2	(150)		BOL Issue Office
DOC_ISSUED_BY	VARCHAR2	(150)		BOL Issued By
DOC_DATE_ISSUED	DATE			BOL Date Issued
SHIPPER_HM_BY	VARCHAR2	(150)		Shipper Hm By
SHIPPER_HM_DATE	DATE			Shipper Hm Date
CARRIER_HM_BY	VARCHAR2	(150)		Carrier Hm By
CARRIER_HM_DATE	DATE			Carrier Hm Date
EXPECTED_POD_DATE	DATE			Expected POD Date

Query Text

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


SELECT DOCUMENT_INSTANCE_ID
,      ENTITY_NAME
,      ENTITY_ID
,      _LA:DOCUMENT_TYPE
,      SEQUENCE_NUMBER
,      STATUS
,      FINAL_PRINT_DATE
,      DOC_SEQUENCE_CATEGORY_ID
,      DOCUMENT_CODE
,      _LA:ENABLED_FLAG
,      _DF
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      POD_FLAG
,      POD_BY
,      POD_DATE
,      REASON_OF_TRANSPORT
,      DESCRIPTION
,      COD_AMOUNT
,      COD_CURRENCY_CODE
,      COD_REMIT_TO
,      COD_CHARGE_PAID_BY
,      PROBLEM_CONTACT_REFERENCE
,      BILL_FREIGHT_TO
,      CARRIED_BY
,      PORT_OF_LOADING
,      PORT_OF_DISCHARGE
,      BOOKING_OFFICE
,      BOOKING_NUMBER
,      SERVICE_CONTRACT
,      SHIPPER_EXPORT_REF
,      CARRIER_EXPORT_REF
,      DOC_NOTIFY_PARTY
,      AETC_NUMBER
,      SHIPPER_SIGNED_BY
,      SHIPPER_DATE
,      CARRIER_SIGNED_BY
,      CARRIER_DATE
,      DOC_ISSUE_OFFICE
,      DOC_ISSUED_BY
,      DOC_DATE_ISSUED
,      SHIPPER_HM_BY
,      SHIPPER_HM_DATE
,      CARRIER_HM_BY
,      CARRIER_HM_DATE
,      EXPECTED_POD_DATE
FROM APPS.WSHFV_DOCUMENT_PACKSLIP;

Dependencies

[top of page]

APPS.WSHFV_DOCUMENT_PACKSLIP references the following:

APPS: WSH_DELIVERY_LEGS; WSH_DOCUMENT_INSTANCES; WSH_DOC_SEQUENCE_CATEGORIES; WSH_NEW_DELIVERIES

APPS.WSHFV_DOCUMENT_PACKSLIP is not referenced by any database object