[Home] [Help] [Dependency Information]
Object Name: | MSC_ATP_SD_DETAILS_TEMP |
---|---|
Object Type: | TABLE |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
MSC.MSC_ATP_SD_DETAILS_TEMP is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SESSION_ID | NUMBER | |||
ORDER_LINE_ID | NUMBER | |||
PEGGING_ID | NUMBER | |||
PARENT_PEGGING_ID | NUMBER | |||
ATP_LEVEL | NUMBER | |||
REQUEST_ITEM_ID | NUMBER | |||
INVENTORY_ITEM_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
DEPARTMENT_ID | NUMBER | |||
RESOURCE_ID | NUMBER | |||
SUPPLIER_ID | NUMBER | |||
SUPPLIER_SITE_ID | NUMBER | |||
FROM_ORGANIZATION_ID | NUMBER | |||
FROM_LOCATION_ID | NUMBER | |||
TO_ORGANIZATION_ID | NUMBER | |||
TO_LOCATION_ID | NUMBER | |||
SHIP_METHOD | VARCHAR2 | (30) | ||
UOM_CODE | VARCHAR2 | (3) | ||
IDENTIFIER1 | NUMBER | |||
IDENTIFIER2 | NUMBER | |||
IDENTIFIER3 | NUMBER | |||
IDENTIFIER4 | NUMBER | |||
SUPPLY_DEMAND_TYPE | NUMBER | |||
SUPPLY_DEMAND_DATE | DATE | |||
SUPPLY_DEMAND_QUANTITY | NUMBER | |||
SUPPLY_DEMAND_SOURCE_TYPE | NUMBER | |||
SCENARIO_ID | NUMBER | |||
DISPOSITION_TYPE | NUMBER | |||
DISPOSITION_NAME | VARCHAR2 | (80) | ||
SUPPLY_DEMAND_SOURCE_TYPE_NAME | VARCHAR2 | (80) | ||
END_PEGGING_ID | NUMBER | |||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
UNALLOCATED_QUANTITY | NUMBER | |||
PF_DISPLAY_FLAG | NUMBER | |||
ORIGINAL_DEMAND_QUANTITY | NUMBER | |||
ORIGINAL_DEMAND_DATE | DATE | |||
ORIGINAL_ITEM_ID | NUMBER | |||
ORIGINAL_SUPPLY_DEMAND_TYPE | NUMBER | |||
ALLOCATED_QUANTITY | NUMBER | |||
ORIG_CUSTOMER_SITE_NAME | VARCHAR2 | (255) | ||
ORIG_CUSTOMER_NAME | VARCHAR2 | (60) | ||
ORIG_DEMAND_CLASS | VARCHAR2 | (34) | ||
ORIG_REQUEST_DATE | DATE | |||
INVENTORY_ITEM_NAME | VARCHAR2 | (250) |
Cut, paste (and edit) the following text to query this object:
SELECT SESSION_ID
, ORDER_LINE_ID
, PEGGING_ID
, PARENT_PEGGING_ID
, ATP_LEVEL
, REQUEST_ITEM_ID
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, DEPARTMENT_ID
, RESOURCE_ID
, SUPPLIER_ID
, SUPPLIER_SITE_ID
, FROM_ORGANIZATION_ID
, FROM_LOCATION_ID
, TO_ORGANIZATION_ID
, TO_LOCATION_ID
, SHIP_METHOD
, UOM_CODE
, IDENTIFIER1
, IDENTIFIER2
, IDENTIFIER3
, IDENTIFIER4
, SUPPLY_DEMAND_TYPE
, SUPPLY_DEMAND_DATE
, SUPPLY_DEMAND_QUANTITY
, SUPPLY_DEMAND_SOURCE_TYPE
, SCENARIO_ID
, DISPOSITION_TYPE
, DISPOSITION_NAME
, SUPPLY_DEMAND_SOURCE_TYPE_NAME
, END_PEGGING_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, UNALLOCATED_QUANTITY
, PF_DISPLAY_FLAG
, ORIGINAL_DEMAND_QUANTITY
, ORIGINAL_DEMAND_DATE
, ORIGINAL_ITEM_ID
, ORIGINAL_SUPPLY_DEMAND_TYPE
, ALLOCATED_QUANTITY
, ORIG_CUSTOMER_SITE_NAME
, ORIG_CUSTOMER_NAME
, ORIG_DEMAND_CLASS
, ORIG_REQUEST_DATE
, INVENTORY_ITEM_NAME
FROM MSC.MSC_ATP_SD_DETAILS_TEMP;
MSC.MSC_ATP_SD_DETAILS_TEMP does not reference any database object
MSC.MSC_ATP_SD_DETAILS_TEMP is referenced by following:
|
|
|