eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: RLM.RLM_COMP_SCHED_TO_DEMAND_TEMP

Object Details

Object Name:	RLM_COMP_SCHED_TO_DEMAND_TEMP
Object Type:	TABLE
Owner:	RLM
Subobject Name:
Status:	VALID

Temporary Table Details

RLM.RLM_COMP_SCHED_TO_DEMAND_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$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

Name	Datatype	Length
SCH_HEADER_ID	NUMBER
CUSTOMER_ID	NUMBER
SCHEDULE_TYPE	VARCHAR2	(30)
SCHED_HORIZON_END_DATE	DATE
SCHED_HORIZON_START_DATE	DATE
SCHEDULE_SOURCE	VARCHAR2	(30)
SCHEDULE_PURPOSE	VARCHAR2	(30)
SCHEDULE_REFERENCE_NUM	VARCHAR2	(35)
SCHED_GENERATION_DATE	DATE
ECE_TP_LOCATION_CODE_EXT	VARCHAR2	(35)
ECE_TP_TRANSLATOR_CODE	VARCHAR2	(35)
LAST_UPDATE_DATE	DATE
CREATION_DATE	DATE
SCH_LINE_ID	NUMBER
CUSTOMER_ITEM_ID	NUMBER
DATE_TYPE_CODE	VARCHAR2	(30)
EDI_TEST_INDICATOR	VARCHAR2	(1)
INVENTORY_ITEM_ID	NUMBER
ITEM_DETAIL_SUBTYPE	VARCHAR2	(30)
ITEM_DETAIL_TYPE	VARCHAR2	(30)
QTY_TYPE_CODE	VARCHAR2	(30)
START_DATE_TIME	DATE
END_DATE_TIME	DATE
ITEM_DETAIL_QUANTITY	NUMBER
UOM_CODE	VARCHAR2	(3)
SHIP_FROM_ORG_ID	NUMBER
SHIP_TO_ORG_ID	NUMBER
SHIP_TO_ADDRESS_ID	NUMBER
INTMED_SHIP_TO_ORG_ID	NUMBER
CUSTOMER_DOCK_CODE	VARCHAR2	(35)
CUSTOMER_JOB	VARCHAR2	(35)
CUST_MODEL_SERIAL_NUMBER	VARCHAR2	(35)
CUST_PRODUCTION_LINE	VARCHAR2	(35)
CUST_PRODUCTION_SEQ_NUM	VARCHAR2	(35)
WEEK_START_DATE	DATE
WEEK_SCHEDULE_QTY	NUMBER
WEEK_END_DATE	DATE
ORDER_HEADER_ID	NUMBER
CUST_PO_NUMBER	VARCHAR2	(50)
CUSTOMER_ITEM_REVISION	VARCHAR2	(3)
PULL_SIGNAL_START_SERIAL_NUM	VARCHAR2	(150)
PULL_SIGNAL_END_SERIAL_NUM	VARCHAR2	(150)
PULL_SIGNAL_REF_NUM	VARCHAR2	(150)
CUSTOMER_REQUEST_DATE	VARCHAR2	(150)
RECORD_YEAR	VARCHAR2	(150)
REQUEST_DATE	DATE
WEEK_NAME	VARCHAR2	(150)
CUSTOMER_NAME	VARCHAR2	(240)

Query Text

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


SELECT SCH_HEADER_ID
,      CUSTOMER_ID
,      SCHEDULE_TYPE
,      SCHED_HORIZON_END_DATE
,      SCHED_HORIZON_START_DATE
,      SCHEDULE_SOURCE
,      SCHEDULE_PURPOSE
,      SCHEDULE_REFERENCE_NUM
,      SCHED_GENERATION_DATE
,      ECE_TP_LOCATION_CODE_EXT
,      ECE_TP_TRANSLATOR_CODE
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      SCH_LINE_ID
,      CUSTOMER_ITEM_ID
,      DATE_TYPE_CODE
,      EDI_TEST_INDICATOR
,      INVENTORY_ITEM_ID
,      ITEM_DETAIL_SUBTYPE
,      ITEM_DETAIL_TYPE
,      QTY_TYPE_CODE
,      START_DATE_TIME
,      END_DATE_TIME
,      ITEM_DETAIL_QUANTITY
,      UOM_CODE
,      SHIP_FROM_ORG_ID
,      SHIP_TO_ORG_ID
,      SHIP_TO_ADDRESS_ID
,      INTMED_SHIP_TO_ORG_ID
,      CUSTOMER_DOCK_CODE
,      CUSTOMER_JOB
,      CUST_MODEL_SERIAL_NUMBER
,      CUST_PRODUCTION_LINE
,      CUST_PRODUCTION_SEQ_NUM
,      WEEK_START_DATE
,      WEEK_SCHEDULE_QTY
,      WEEK_END_DATE
,      ORDER_HEADER_ID
,      CUST_PO_NUMBER
,      CUSTOMER_ITEM_REVISION
,      PULL_SIGNAL_START_SERIAL_NUM
,      PULL_SIGNAL_END_SERIAL_NUM
,      PULL_SIGNAL_REF_NUM
,      CUSTOMER_REQUEST_DATE
,      RECORD_YEAR
,      REQUEST_DATE
,      WEEK_NAME
,      CUSTOMER_NAME
FROM RLM.RLM_COMP_SCHED_TO_DEMAND_TEMP;

Dependencies

[top of page]

RLM.RLM_COMP_SCHED_TO_DEMAND_TEMP does not reference any database object

RLM.RLM_COMP_SCHED_TO_DEMAND_TEMP is referenced by following:

APPS: RLM_COMP_SCHED_TO_DEMAND_TEMP