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: WMS.WMS_API_HOOK_CALLS

Object Details

Object Name:	WMS_API_HOOK_CALLS
Object Type:	TABLE
Owner:	WMS
FND Design Data:	WMS.WMS_API_HOOK_CALLS
Subobject Name:
Status:	VALID

Stores details of seeded and custom APIs for ATF destination locator and LPN determination. The HOOK_CALL_ID corresponds to the either LPN_SELECTION_API_ID or LOC_SELECTION_API_ID specified on the Operation Plan details table (WMS_OP_PLAN_DETAILS). Seeded API names are listed in the WMS lookup type WMS_CHILD_SHORT_NAMES. The DESCRIPTION_ID column on this table corresponds to the lookup code.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
HOOK_CALL_ID	NUMBER		Yes	Unique identifier
MODULE_HOOK_ID	NUMBER		Yes	Parent API identifier
ENABLED_FLAG	VARCHAR2	(10)	Yes	Enabled flag
CALLED_PACKAGE	VARCHAR2	(100)	Yes	Name of package that is called at runtime
CALLED_PROCEDURE	VARCHAR2	(100)	Yes	Name of procedure in CALLED_PACKAGE that is executed
EFFECTIVE_FROM_DATE	DATE			Lower bound of effective date range
EFFECTIVE_TO_DATE	DATE			Upper bound of effective date range
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
SEED_FLAG	VARCHAR2	(1)		Indicates if the API is a seeded one, or a custom API
DESCRIPTION	VARCHAR2	(240)		Description of the API
DESCRIPTION_ID	NUMBER			For seeded APIs, refers to the lookup code within lookup type WMS_CHILD_SHORT_NAMES which describes the API

Query Text

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


SELECT HOOK_CALL_ID
,      MODULE_HOOK_ID
,      ENABLED_FLAG
,      CALLED_PACKAGE
,      CALLED_PROCEDURE
,      EFFECTIVE_FROM_DATE
,      EFFECTIVE_TO_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      SEED_FLAG
,      DESCRIPTION
,      DESCRIPTION_ID
FROM WMS.WMS_API_HOOK_CALLS;

Dependencies

[top of page]

WMS.WMS_API_HOOK_CALLS does not reference any database object

WMS.WMS_API_HOOK_CALLS is referenced by following:

APPS: WMS_API_HOOK_CALLS