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]

TABLE: WSH.WSH_PR_HEADER_HOLDS

Object Details

Object Name:	WSH_PR_HEADER_HOLDS
Object Type:	TABLE
Owner:	WSH
Subobject Name:
Status:	VALID

This table is used to store the Order Headers that have been already checked for Credit Holds during each Pick Release process run.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER		Yes	Pick Release Batch Id
HEADER_ID	NUMBER		Yes	Order Header Id
STATUS	VARCHAR2	(1)	Yes	Status P(Pass)/F(Fail)

Query Text

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


SELECT BATCH_ID
,      HEADER_ID
,      STATUS
FROM WSH.WSH_PR_HEADER_HOLDS;

Dependencies

[top of page]

WSH.WSH_PR_HEADER_HOLDS does not reference any database object

WSH.WSH_PR_HEADER_HOLDS is referenced by following:

APPS: WSH_PR_HEADER_HOLDS