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

Object Details

Object Name:	CSP_STOCKING_SITE_DETAILS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Comments
ORGANIZATION_ID	NUMBER	(35)	Organization Identifier
ORGANIZATION_CODE	VARCHAR2	(3)	Organization Code
ORGANIZATION_NAME	VARCHAR2	(240)	Organization Name
SUBINVENTORY_CODE	VARCHAR2	(10)	Subinventory Code
LOCATION_ID	NUMBER		Location identifier
ADDRESS	VARCHAR2	(4000)	Address
STOCKING_SITE_TYPE	VARCHAR2	(30)	Stocking Site Type
STOCKING_SITE	VARCHAR2	(80)	Stocking Site
LOCAL_TIME	DATE		Local Time
OPEN_OR_CLOSED	VARCHAR2	(80)	Warehouse Open or Closed
TODAY_OPEN	DATE		Warehouse open time today
TODAY_CLOSE	DATE		Warehouse close time today
NEXT_DAY_OPEN	DATE		Warehouse open time next day
NEXT_DAY_CLOSE	DATE		Warehouse close time next day
TIMEZONE	VARCHAR2	(80)	Timezone
MANAGED_BY	VARCHAR2	(30)	Warehouse Managed By
CONTACT_NAME	VARCHAR2	(360)	Contact Name
CONTACT_PHONE	VARCHAR2	(2000)	Contact Phone
AH_CONTACT_NAME	VARCHAR2	(150)	After Hours Contact Name
AH_CONTACT_PHONE	VARCHAR2	(30)	After Hours Contact Phone
SPECIAL_INSTRUCTIONS	VARCHAR2	(1996)	Special Instructions
HZ_LOCATION_ID	NUMBER		Geocoded Address Identifier

Query Text

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


SELECT ORGANIZATION_ID
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      SUBINVENTORY_CODE
,      LOCATION_ID
,      ADDRESS
,      STOCKING_SITE_TYPE
,      STOCKING_SITE
,      LOCAL_TIME
,      OPEN_OR_CLOSED
,      TODAY_OPEN
,      TODAY_CLOSE
,      NEXT_DAY_OPEN
,      NEXT_DAY_CLOSE
,      TIMEZONE
,      MANAGED_BY
,      CONTACT_NAME
,      CONTACT_PHONE
,      AH_CONTACT_NAME
,      AH_CONTACT_PHONE
,      SPECIAL_INSTRUCTIONS
,      HZ_LOCATION_ID
FROM APPS.CSP_STOCKING_SITE_DETAILS_V;

Dependencies

[top of page]

APPS.CSP_STOCKING_SITE_DETAILS_V references the following:

APPS: CAC_SR_OBJECT_CAPACITY; CSP_NEXT_OPEN_V; CSP_OPEN_CLOSED_V; CSP_PLANNING_PARAMETERS; CSP_SEC_INVENTORIES; FND_LOOKUP_VALUES_VL; FND_PROFILE - show dependent code; HR_ALL_ORGANIZATION_UNITS; HZ_FORMAT_PUB - show dependent code; HZ_TIMEZONES_VL; HZ_TIMEZONE_PUB - show dependent code; JTF_RS_RESOURCE_EXTNS; MTL_PARAMETERS
PUBLIC: DUAL

APPS.CSP_STOCKING_SITE_DETAILS_V is referenced by following:

APPS: CSP_TRANSACTIONS_PUB - show dependent code