DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.WSHFV_CONTAINER_ITEMS

Object Details
Object Name: WSHFV_CONTAINER_ITEMS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewWSH.WSHFV_CONTAINER_ITEMS
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 Comments
MASTER_ORGANIZATION_ID NUMBER
Yes Master Organization Id
ORGANIZATION_CODE VARCHAR2 (3)
Organization Code
ORGANIZATION_NAME VARCHAR2 (240) Yes Organization Name
CONTAINER_ITEM_ID NUMBER
Yes Container Item Id
_KF:CONTAINER_ITEM_ID CHAR (17)
Key Flexfield - Container Item
_LA:PREFERRED_FLAG CHAR (45)
Lookup- Preferred Flag
_DF CHAR (31)
Descriptive Flexfield
LOAD_ITEM_ID NUMBER
Yes Load Item Id
_KF:LOAD_ITEM_ID CHAR (17)
Key Flexfield - Load Item
MAX_LOAD_QUANTITY NUMBER
Yes Max Load Quantity
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

Query Text

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


SELECT MASTER_ORGANIZATION_ID
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      CONTAINER_ITEM_ID
,      _KF:CONTAINER_ITEM_ID
,      _LA:PREFERRED_FLAG
,      _DF
,      LOAD_ITEM_ID
,      _KF:LOAD_ITEM_ID
,      MAX_LOAD_QUANTITY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM APPS.WSHFV_CONTAINER_ITEMS;

Dependencies

[top of page]

APPS.WSHFV_CONTAINER_ITEMS references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS
SynonymWSH_CONTAINER_ITEMS

APPS.WSHFV_CONTAINER_ITEMS is not referenced by any database object