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]

VIEW: RLM.RLM_DEMAND_EXCEPTIONS#

Object Details

Object Name:	RLM_DEMAND_EXCEPTIONS#
Object Type:	VIEW
Owner:	RLM
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
EXCEPTION_ID	NUMBER		Yes
MESSAGE_NAME	VARCHAR2	(30)	Yes
EXCEPTION_LEVEL	VARCHAR2	(1)	Yes
CUST_BILL_TO_EXT	VARCHAR2	(35)
CUST_INTERMD_SHIPTO_EXT	VARCHAR2	(35)
CUST_ITEM_DESCRIPTION	VARCHAR2	(80)
CUST_JOB_NUMBER	VARCHAR2	(50)
CUST_MODEL_SERIAL_NUM	VARCHAR2	(35)
CUST_NAME_EXT	VARCHAR2	(360)
CUSTOMER_PROD_SEQ_NUM	VARCHAR2	(35)
CUST_SHIP_FROM_ORG_EXT	VARCHAR2	(80)
CUST_SHIP_TO_EXT	VARCHAR2	(35)
CUST_UOM_EXT	VARCHAR2	(10)
CUSTOMER_ITEM_EXT	VARCHAR2	(50)
DATE_TYPE_CODE	VARCHAR2	(30)
ECE_TP_LOCATION_CODE_EXT	VARCHAR2	(35)
ECE_TP_TRANSLATOR_CODE	VARCHAR2	(35)
EDI_CONTROL_NUM_3	VARCHAR2	(15)
EDI_TEST_INDICATOR	VARCHAR2	(1)
EXCEPTION_ATTRIBUTE1	VARCHAR2	(150)
EXCEPTION_ATTRIBUTE10	VARCHAR2	(150)
EXCEPTION_ATTRIBUTE11	VARCHAR2	(150)
EXCEPTION_ATTRIBUTE12	VARCHAR2	(150)
EXCEPTION_ATTRIBUTE13	VARCHAR2	(150)
EXCEPTION_ATTRIBUTE14	VARCHAR2	(150)
EXCEPTION_ATTRIBUTE15	VARCHAR2	(150)
EXCEPTION_ATTRIBUTE16	VARCHAR2	(150)
EXCEPTION_ATTRIBUTE17	VARCHAR2	(150)
EXCEPTION_ATTRIBUTE18	VARCHAR2	(150)
EXCEPTION_ATTRIBUTE19	VARCHAR2	(150)
EXCEPTION_ATTRIBUTE2	VARCHAR2	(150)
EXCEPTION_ATTRIBUTE20	VARCHAR2	(150)
EXCEPTION_ATTRIBUTE3	VARCHAR2	(150)
EXCEPTION_ATTRIBUTE4	VARCHAR2	(150)
EXCEPTION_ATTRIBUTE5	VARCHAR2	(150)
EXCEPTION_ATTRIBUTE6	VARCHAR2	(150)
EXCEPTION_ATTRIBUTE7	VARCHAR2	(150)
EXCEPTION_ATTRIBUTE8	VARCHAR2	(150)
EXCEPTION_ATTRIBUTE9	VARCHAR2	(150)
ITEM_DETAIL_QUANTITY	NUMBER
ITEM_DETAIL_SUBTYPE	VARCHAR2	(30)
ITEM_DETAIL_TYPE	VARCHAR2	(30)
MESSAGE_TEXT	VARCHAR2	(3999)
QTY_TYPE_CODE	VARCHAR2	(30)
INTERFACE_HEADER_ID	NUMBER
INTERFACE_LINE_ID	NUMBER
SCHEDULE_HEADER_ID	NUMBER
SCHEDULE_LINE_ID	NUMBER
SCHEDULE_TYPE	VARCHAR2	(30)
SCHED_GENERATION_DATE	DATE
SCHEDULE_ITEM_NUM	NUMBER
SCHEDULE_PURPOSE	VARCHAR2	(30)
SCHEDULE_REFERENCE_NUM	VARCHAR2	(35)
SCHEDULE_SOURCE	VARCHAR2	(30)
START_DATE_TIME	DATE
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER		Yes
LAST_UPDATE_LOGIN	NUMBER
REQUEST_ID	NUMBER
PROGRAM_APPLICATION_ID	NUMBER
PROGRAM_ID	NUMBER
PROGRAM_UPDATE_DATE	DATE
INVENTORY_ITEM	VARCHAR2	(50)
SCHEDULE_LINE_NUMBER	NUMBER
HORIZON_START_DATE	DATE
HORIZON_END_DATE	DATE
ORDER_HEADER_ID	NUMBER
ORDER_LINE_ID	NUMBER
REQUEST_DATE	DATE
INDUSTRY_ATTRIBUTE1	VARCHAR2	(150)
SCHEDULE_DATE	VARCHAR2	(240)
CUST_PO_NUMBER	VARCHAR2	(50)
CUSTOMER_DOCK_CODE	VARCHAR2	(35)
CUST_PRODUCTION_LINE	VARCHAR2	(50)
PURGE_STATUS	VARCHAR2	(30)
ORIGIN_TABLE	VARCHAR2	(9)
REPORT_SUMMARY	CLOB	(4000)

Query Text

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


SELECT EXCEPTION_ID
,      MESSAGE_NAME
,      EXCEPTION_LEVEL
,      CUST_BILL_TO_EXT
,      CUST_INTERMD_SHIPTO_EXT
,      CUST_ITEM_DESCRIPTION
,      CUST_JOB_NUMBER
,      CUST_MODEL_SERIAL_NUM
,      CUST_NAME_EXT
,      CUSTOMER_PROD_SEQ_NUM
,      CUST_SHIP_FROM_ORG_EXT
,      CUST_SHIP_TO_EXT
,      CUST_UOM_EXT
,      CUSTOMER_ITEM_EXT
,      DATE_TYPE_CODE
,      ECE_TP_LOCATION_CODE_EXT
,      ECE_TP_TRANSLATOR_CODE
,      EDI_CONTROL_NUM_3
,      EDI_TEST_INDICATOR
,      EXCEPTION_ATTRIBUTE1
,      EXCEPTION_ATTRIBUTE10
,      EXCEPTION_ATTRIBUTE11
,      EXCEPTION_ATTRIBUTE12
,      EXCEPTION_ATTRIBUTE13
,      EXCEPTION_ATTRIBUTE14
,      EXCEPTION_ATTRIBUTE15
,      EXCEPTION_ATTRIBUTE16
,      EXCEPTION_ATTRIBUTE17
,      EXCEPTION_ATTRIBUTE18
,      EXCEPTION_ATTRIBUTE19
,      EXCEPTION_ATTRIBUTE2
,      EXCEPTION_ATTRIBUTE20
,      EXCEPTION_ATTRIBUTE3
,      EXCEPTION_ATTRIBUTE4
,      EXCEPTION_ATTRIBUTE5
,      EXCEPTION_ATTRIBUTE6
,      EXCEPTION_ATTRIBUTE7
,      EXCEPTION_ATTRIBUTE8
,      EXCEPTION_ATTRIBUTE9
,      ITEM_DETAIL_QUANTITY
,      ITEM_DETAIL_SUBTYPE
,      ITEM_DETAIL_TYPE
,      MESSAGE_TEXT
,      QTY_TYPE_CODE
,      INTERFACE_HEADER_ID
,      INTERFACE_LINE_ID
,      SCHEDULE_HEADER_ID
,      SCHEDULE_LINE_ID
,      SCHEDULE_TYPE
,      SCHED_GENERATION_DATE
,      SCHEDULE_ITEM_NUM
,      SCHEDULE_PURPOSE
,      SCHEDULE_REFERENCE_NUM
,      SCHEDULE_SOURCE
,      START_DATE_TIME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      INVENTORY_ITEM
,      SCHEDULE_LINE_NUMBER
,      HORIZON_START_DATE
,      HORIZON_END_DATE
,      ORDER_HEADER_ID
,      ORDER_LINE_ID
,      REQUEST_DATE
,      INDUSTRY_ATTRIBUTE1
,      SCHEDULE_DATE
,      CUST_PO_NUMBER
,      CUSTOMER_DOCK_CODE
,      CUST_PRODUCTION_LINE
,      PURGE_STATUS
,      ORIGIN_TABLE
,      REPORT_SUMMARY
FROM RLM.RLM_DEMAND_EXCEPTIONS#;

Dependencies

[top of page]

RLM.RLM_DEMAND_EXCEPTIONS# references the following:

RLM: RLM_DEMAND_EXCEPTIONS

RLM.RLM_DEMAND_EXCEPTIONS# is referenced by following:

APPS: RLM_DEMAND_EXCEPTIONS