[Home] [Help] [Dependency Information]
Object Name: | CSP_STOCKING_SITE_DETAILS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
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.
Name | Datatype | Length | Mandatory | 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 |
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;
|
|
|