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

Object Details

Object Name:	WSHBV_DOCUMENT_PACKSLIP
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WSH.WSHBV_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
DOCUMENT_INSTANCE_ID	NUMBER		Yes
ENTITY_NAME	VARCHAR2	(50)	Yes
ENTITY_ID	NUMBER		Yes
_LA:DOCUMENT_TYPE	CHAR	(51)
SEQUENCE_NUMBER	VARCHAR2	(50)	Yes
STATUS	VARCHAR2	(30)
FINAL_PRINT_DATE	DATE
DOC_SEQUENCE_CATEGORY_ID	NUMBER
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_BY	VARCHAR2	(150)
POD_DATE	DATE
REASON_OF_TRANSPORT	VARCHAR2	(30)
DESCRIPTION	VARCHAR2	(30)
COD_AMOUNT	NUMBER
COD_CURRENCY_CODE	VARCHAR2	(15)
COD_REMIT_TO	VARCHAR2	(150)
COD_CHARGE_PAID_BY	VARCHAR2	(150)
PROBLEM_CONTACT_REFERENCE	VARCHAR2	(500)
BILL_FREIGHT_TO	VARCHAR2	(1000)
CARRIED_BY	VARCHAR2	(150)
PORT_OF_LOADING	VARCHAR2	(150)
PORT_OF_DISCHARGE	VARCHAR2	(150)
BOOKING_OFFICE	VARCHAR2	(50)
BOOKING_NUMBER	VARCHAR2	(30)
SERVICE_CONTRACT	VARCHAR2	(30)
SHIPPER_EXPORT_REF	VARCHAR2	(30)
CARRIER_EXPORT_REF	VARCHAR2	(30)
DOC_NOTIFY_PARTY	VARCHAR2	(30)
AETC_NUMBER	VARCHAR2	(30)
SHIPPER_SIGNED_BY	VARCHAR2	(150)
SHIPPER_DATE	DATE
CARRIER_SIGNED_BY	VARCHAR2	(150)
CARRIER_DATE	DATE
DOC_ISSUE_OFFICE	VARCHAR2	(150)
DOC_ISSUED_BY	VARCHAR2	(150)
DOC_DATE_ISSUED	DATE
SHIPPER_HM_BY	VARCHAR2	(150)
SHIPPER_HM_DATE	DATE
CARRIER_HM_BY	VARCHAR2	(150)
CARRIER_HM_DATE	DATE
EXPECTED_POD_DATE	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
,      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.WSHBV_DOCUMENT_PACKSLIP;

Dependencies

[top of page]

APPS.WSHBV_DOCUMENT_PACKSLIP references the following:

APPS: WSH_DELIVERY_LEGS; WSH_DOCUMENT_INSTANCES; WSH_NEW_DELIVERIES

APPS.WSHBV_DOCUMENT_PACKSLIP is not referenced by any database object