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

TABLE: CSP.CSP_SUP_DEM_PLS

Object Details
Object Name: CSP_SUP_DEM_PLS
Object Type: TABLE
Owner: CSP
Subobject Name:
Status: VALID


Supply and demand for Parts Loops.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CSP_SUP_DEM_PLS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARTS_LOOP_ID
ColumnINVENTORY_ITEM_ID
Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER (38) Yes Inventory item identifier
ORGANIZATION_ID NUMBER (38)
Organization identifier
PARTS_LOOP_ID NUMBER (38)
Parts Loop identifier
PURCHASE_ORDERS NUMBER (38)
Purchase order quantity
SALES_ORDERS NUMBER (38)
Sales order quantity
REQUISITIONS NUMBER (38)
Requisition quantity
INTERORG_TRANSF_IN NUMBER (38)
Incoming interorganization transfer quantity
ONHAND_GOOD NUMBER (38)
Usable quantity onhand
ONHAND_BAD NUMBER (38)
Defective quantity onhand
INTRANSIT_MOVE_ORDERS NUMBER (38)
Move Order quantity in intransit
INTERORG_TRANSF_OUT NUMBER (38)
Outgoing inter organization transfer quantity
MOVE_ORDERS_IN NUMBER (38)
Incoming move order quantity
MOVE_ORDERS_OUT NUMBER (38)
Outgoing move order quantity
WORK_ORDERS NUMBER (38)
Work order quantity
Query Text

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


SELECT INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      PARTS_LOOP_ID
,      PURCHASE_ORDERS
,      SALES_ORDERS
,      REQUISITIONS
,      INTERORG_TRANSF_IN
,      ONHAND_GOOD
,      ONHAND_BAD
,      INTRANSIT_MOVE_ORDERS
,      INTERORG_TRANSF_OUT
,      MOVE_ORDERS_IN
,      MOVE_ORDERS_OUT
,      WORK_ORDERS
FROM CSP.CSP_SUP_DEM_PLS;

Dependencies

[top of page]

CSP.CSP_SUP_DEM_PLS does not reference any database object

CSP.CSP_SUP_DEM_PLS is referenced by following:

SchemaCSP
ViewCSP_SUP_DEM_PLS#