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: QP.QP_DEBUG_REQ#

Object Details

Object Name:	QP_DEBUG_REQ#
Object Type:	VIEW
Owner:	QP
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
REQUEST_ID	NUMBER		Yes
REQUEST_NAME	VARCHAR2	(240)	Yes
CREATED_BY	NUMBER		Yes
CREATION_DATE	DATE		Yes
PRICING_EVENT	VARCHAR2	(30)
CALCULATE_FLAG	VARCHAR2	(30)	Yes
SIMULATION_FLAG	VARCHAR2	(1)
REQUEST_TYPE_CODE	VARCHAR2	(30)	Yes
VIEW_CODE	VARCHAR2	(50)
ROUNDING_FLAG	VARCHAR2	(1)
GSA_CHECK_FLAG	VARCHAR2	(1)
GSA_DUP_CHECK_FLAG	VARCHAR2	(1)
TEMP_TABLE_INSERT_FLAG	VARCHAR2	(1)
MANUAL_DISCOUNT_FLAG	VARCHAR2	(1)
DEBUG_FLAG	VARCHAR2	(1)
SOURCE_ORDER_AMOUNT_FLAG	VARCHAR2	(1)
PUBLIC_API_CALL_FLAG	VARCHAR2	(1)
MANUAL_ADJUSTMENTS_CALL_FLAG	VARCHAR2	(1)
CHECK_CUST_VIEW_FLAG	VARCHAR2	(1)
CURRENCY_CODE	VARCHAR2	(30)
ORDER_NUMBER	VARCHAR2	(50)

Query Text

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


SELECT REQUEST_ID
,      REQUEST_NAME
,      CREATED_BY
,      CREATION_DATE
,      PRICING_EVENT
,      CALCULATE_FLAG
,      SIMULATION_FLAG
,      REQUEST_TYPE_CODE
,      VIEW_CODE
,      ROUNDING_FLAG
,      GSA_CHECK_FLAG
,      GSA_DUP_CHECK_FLAG
,      TEMP_TABLE_INSERT_FLAG
,      MANUAL_DISCOUNT_FLAG
,      DEBUG_FLAG
,      SOURCE_ORDER_AMOUNT_FLAG
,      PUBLIC_API_CALL_FLAG
,      MANUAL_ADJUSTMENTS_CALL_FLAG
,      CHECK_CUST_VIEW_FLAG
,      CURRENCY_CODE
,      ORDER_NUMBER
FROM QP.QP_DEBUG_REQ#;

Dependencies

[top of page]

QP.QP_DEBUG_REQ# references the following:

QP: QP_DEBUG_REQ

QP.QP_DEBUG_REQ# is referenced by following:

APPS: QP_DEBUG_REQ