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: QP.QP_UPG_LINES_DISTRIBUTION

Object Details

Object Name:	QP_UPG_LINES_DISTRIBUTION
Object Type:	TABLE
Owner:	QP
FND Design Data:	QP.QP_UPG_LINES_DISTRIBUTION
Subobject Name:
Status:	VALID

QP_UPG_LINES_DISTRIBUTION

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
WORKER	NUMBER		stores the worker number
START_LINE_ID	NUMBER		starting line id or header id or formula_id or adjustment_id or agreement_id for the worker
END_LINE_ID	NUMBER		ending line id or header id or formula_id or adjustment_id or agreement_id for the worker
ALLOTED_FLAG	VARCHAR2	(1)	currently not used
LINE_TYPE	VARCHAR2	(30)	indicates whether it is a price list line(PLL) or agreement(AGR) etc..
CREATION_DATE	DATE		date on which this row was created
LAST_PROC_LINE	NUMBER		This column is used to store the last processed line's Id and is used to make the Qualification Ind Denormalization script re-runnable. If the script is re-started after a worker failure, then it will not start processing all lines all over again but instead will continue from the line after the last processed line.

Query Text

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


SELECT WORKER
,      START_LINE_ID
,      END_LINE_ID
,      ALLOTED_FLAG
,      LINE_TYPE
,      CREATION_DATE
,      LAST_PROC_LINE
FROM QP.QP_UPG_LINES_DISTRIBUTION;

Dependencies

[top of page]

QP.QP_UPG_LINES_DISTRIBUTION does not reference any database object

QP.QP_UPG_LINES_DISTRIBUTION is referenced by following:

APPS: QP_UPG_LINES_DISTRIBUTION