[Home] [Help] [Dependency Information]
Object Name: | CSP_CURR_SUP_DEM_SUMS |
---|---|
Object Type: | TABLE |
Owner: | CSP |
FND Design Data: | CSP.CSP_CURR_SUP_DEM_SUMS |
Subobject Name: | |
Status: | VALID |
The concurrent program "Create Part Availability Data" populates this table with supply and demand information for service items. This information is used in the Planner's Desktop and also by the concurrent program "Create Notifications".
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CSP_CURR_SUP_DEM_SUMS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
INVENTORY_ITEM_ID
ORGANIZATION_ID |
CSP_CURR_SUP_DEM_SUMS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
SUBINVENTORY_CODE |
CSP_CURR_SUP_DEM_SUMS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | HIERARCHY_NODE_ID |
CSP_CURR_SUP_DEM_SUMS_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PARTS_LOOP_ID |
CSP_CURR_SUP_DEM_SUMS_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PLANNING_PARAMETERS_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUPPLY_DEMAND_ID | NUMBER | (35) | Supply demand unique identifier | |
CREATED_BY | NUMBER | (35) | Yes | Standard Who Column - with the user id from FND_USER |
CREATION_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (35) | Yes | Standard Who Column - with the user id from FND_USER |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (35) | Standard Who Column | |
REQUEST_ID | NUMBER | (35) | Standard Who Column | |
PROGRAM_APPLICATION_ID | NUMBER | (35) | Standard Who Column | |
PROGRAM_ID | NUMBER | (35) | Standard Who Column | |
PROGRAM_UPDATE_DATE | DATE | Standard Who Column | ||
INVENTORY_ITEM_ID | NUMBER | (35) | Yes | Inventory item identifier |
ORGANIZATION_ID | NUMBER | (35) | Organization identifier | |
PARTS_LOOP_ID | NUMBER | (35) | Parts loop identifier | |
HIERARCHY_NODE_ID | NUMBER | (35) | Hierarchy node identifier | |
SUBINVENTORY_CODE | VARCHAR2 | (10) | Subinventory identifier | |
ONHAND_BAD | NUMBER | (35) | Quantity of onhand bad parts | |
ONHAND_GOOD | NUMBER | (35) | Quantity of onhand good parts | |
INTRANSIT_MOVE_ORDERS | NUMBER | (35) | Quantity of item on moveorders being in transit | |
OPEN_INTERORG_TRANSF_IN | NUMBER | (35) | Quantity of item on interorganization transfers expected in | |
OPEN_INTERORG_TRANSF_OUT | NUMBER | (35) | Quantity of item on interorganization transfers expected out | |
OPEN_SALES_ORDERS | NUMBER | (35) | Quantity of item on open sales orders | |
OPEN_MOVE_ORDERS_IN | NUMBER | (35) | Quantity of item on moveorders expected in | |
OPEN_MOVE_ORDERS_OUT | NUMBER | (35) | Quantity of item on moveorders expected out | |
OPEN_REQUISITIONS | NUMBER | (35) | Quantity of item on open requisitions | |
OPEN_PURCHASE_ORDERS | NUMBER | (35) | Quantity of item on open purchase orders | |
OPEN_WORK_ORDERS | NUMBER | (35) | Quantity of item on open work orders | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield Segment Column | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
PLANNING_PARAMETERS_ID | NUMBER | (35) | Planning node identifier | |
EXCESS_QUANTITY | NUMBER | (35) | Excess quantity of item |
Cut, paste (and edit) the following text to query this object:
SELECT SUPPLY_DEMAND_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, PARTS_LOOP_ID
, HIERARCHY_NODE_ID
, SUBINVENTORY_CODE
, ONHAND_BAD
, ONHAND_GOOD
, INTRANSIT_MOVE_ORDERS
, OPEN_INTERORG_TRANSF_IN
, OPEN_INTERORG_TRANSF_OUT
, OPEN_SALES_ORDERS
, OPEN_MOVE_ORDERS_IN
, OPEN_MOVE_ORDERS_OUT
, OPEN_REQUISITIONS
, OPEN_PURCHASE_ORDERS
, OPEN_WORK_ORDERS
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
, PLANNING_PARAMETERS_ID
, EXCESS_QUANTITY
FROM CSP.CSP_CURR_SUP_DEM_SUMS;
CSP.CSP_CURR_SUP_DEM_SUMS does not reference any database object
CSP.CSP_CURR_SUP_DEM_SUMS is referenced by following:
|
|
|