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

VIEW: APPS.CSP_USAGE_HISTORIES_V1

Object Details
Object Name: CSP_USAGE_HISTORIES_V1
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCSP.CSP_USAGE_HISTORIES_V1
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 Mandatory Comments
PERIOD_START_DATE DATE
Yes Period start date
PERIOD_TYPE VARCHAR2 (30) Yes Period type
INVENTORY_ITEM_ID NUMBER (35) Yes Inventory item identifier
ORGANIZATION_ID NUMBER (35) Yes Organization identifier
PARTS_LOOP_ID NUMBER (35)
Parts loop identifier
SUBINVENTORY_CODE VARCHAR2 (30) Yes Subinventory name
HIERARCHY_NODE_ID NUMBER (35)
Hierarchy node identifier
USAGE_QUANTITY NUMBER

Usage quantity
SO_QUANTITY NUMBER

Sales order quantity
FORECAST_QUANTITY NUMBER

Forecast quantity
TOTAL NUMBER

Usage plus sales order quantities
Query Text

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


SELECT PERIOD_START_DATE
,      PERIOD_TYPE
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      PARTS_LOOP_ID
,      SUBINVENTORY_CODE
,      HIERARCHY_NODE_ID
,      USAGE_QUANTITY
,      SO_QUANTITY
,      FORECAST_QUANTITY
,      TOTAL
FROM APPS.CSP_USAGE_HISTORIES_V1;

Dependencies

[top of page]

APPS.CSP_USAGE_HISTORIES_V1 references the following:

SchemaAPPS
SynonymCSP_USAGE_HISTORIES

APPS.CSP_USAGE_HISTORIES_V1 is not referenced by any database object