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

VIEW: APPS.CSP_SUP_DEM_PL_V

Object Details
Object Name: CSP_SUP_DEM_PL_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 Mandatory Comments
INVENTORY_ITEM_ID NUMBER
Yes Item identifier
ITEM_NUMBER VARCHAR2 (40)
Item number
ITEM_DESCRIPTION VARCHAR2 (240)
Item description
PARTS_LOOP_ID NUMBER

Parts loop identifier
PRIMARY_UOM_CODE VARCHAR2 (3)
Primary unit of measure code
ONHAND_BAD NUMBER

Defective onhand quantity
ONHAND_GOOD NUMBER

Usable onhand quantity
INTRANSIT_MOVE_ORDERS NUMBER

Interorg transfer
PURCHASE_ORDERS NUMBER

Purchase orders
SALES_ORDERS NUMBER

Sales orders
WORK_ORDERS NUMBER

Work orders
REQUISITIONS NUMBER

Requisitions
MOVE_ORDERS_IN NUMBER

Move orders in
MOVE_ORDERS_OUT NUMBER

Move orders out
INTERORG_TRANSF_IN NUMBER

Internal orders in
INTERORG_TRANSF_OUT NUMBER

Internal orders out
TRANSFER_IN NUMBER

Transfer in
TRANSFER_OUT NUMBER

Transfer out
CREATION_DATE DATE

Creation date
Query Text

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


SELECT INVENTORY_ITEM_ID
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      PARTS_LOOP_ID
,      PRIMARY_UOM_CODE
,      ONHAND_BAD
,      ONHAND_GOOD
,      INTRANSIT_MOVE_ORDERS
,      PURCHASE_ORDERS
,      SALES_ORDERS
,      WORK_ORDERS
,      REQUISITIONS
,      MOVE_ORDERS_IN
,      MOVE_ORDERS_OUT
,      INTERORG_TRANSF_IN
,      INTERORG_TRANSF_OUT
,      TRANSFER_IN
,      TRANSFER_OUT
,      CREATION_DATE
FROM APPS.CSP_SUP_DEM_PL_V;

Dependencies

[top of page]

APPS.CSP_SUP_DEM_PL_V references the following:

SchemaAPPS
TableCSP_SUP_DEM_PL_MV
ViewMTL_SYSTEM_ITEMS_B_KFV
SchemaPUBLIC
SynonymALL_MVIEWS

APPS.CSP_SUP_DEM_PL_V is not referenced by any database object