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: APPS.QC_TRAN_VW2

Object Details

Object Name:	QC_TRAN_VW2
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMD.QC_TRAN_VW2
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

No longer used in R12

[View Source]

Columns

Name	Datatype	Length	Comments
ITEM_ID	NUMBER	(10)	Item identifier - surrogate key
LOT_ID	NUMBER	(10)	Lot identifier
TARGET_ITEM_ID	NUMBER	(10)	Target Item identifier
TARGET_LOT_ID	NUMBER	(10)	Target lot identifier
COMPLETED_IND	NUMBER		Indicator for completed status
CREATION_DATE	DATE		creation date
DOC_ID	NUMBER	(10)	document identifier surrogate key
DOC_LINE	NUMBER		line on the document
DOC_TYPE	VARCHAR2	(4)	type of document
LINE_ID	NUMBER	(10)	Identifier of the line on the document
LINE_TYPE	NUMBER		Type of line
LOCATION	VARCHAR2	(16)	Location of the material
OP_CODE	NUMBER	(15)	Operation code
ORGN_CODE	VARCHAR2	(4)	Organization code
REASON_CODE	VARCHAR2	(4)	reason code
TEXT_CODE	NUMBER	(10)	Text code
TRANS_DATE	DATE		Date of transaction
TRANS_ID	NUMBER	(10)	Identifier surrogate key of transaction
TRANS_QTY	NUMBER		Quantity of transaction
TRANS_QTY2	NUMBER		QUantity of trnsaction
TRANS_STAT	VARCHAR2	(4)	Status of transaction
TRANS_UM	VARCHAR2	(4)	Unit of measure of transaction auantity
TRANS_UM2	VARCHAR2	(4)	Unit of measure of transaction auantity
WHSE_CODE	VARCHAR2	(4)	Warehouse code
DOC_NO	VARCHAR2	(32)	Document number

Query Text

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


SELECT ITEM_ID
,      LOT_ID
,      TARGET_ITEM_ID
,      TARGET_LOT_ID
,      COMPLETED_IND
,      CREATION_DATE
,      DOC_ID
,      DOC_LINE
,      DOC_TYPE
,      LINE_ID
,      LINE_TYPE
,      LOCATION
,      OP_CODE
,      ORGN_CODE
,      REASON_CODE
,      TEXT_CODE
,      TRANS_DATE
,      TRANS_ID
,      TRANS_QTY
,      TRANS_QTY2
,      TRANS_STAT
,      TRANS_UM
,      TRANS_UM2
,      WHSE_CODE
,      DOC_NO
FROM APPS.QC_TRAN_VW2;

Dependencies

[top of page]

APPS.QC_TRAN_VW2 references the following:

APPS: IC_TRAN_PND; IC_TRAN_VW1; OP_ORDR_DTL; OP_ORDR_HDR; PM_BTCH_HDR; PM_MATL_DTL

APPS.QC_TRAN_VW2 is not referenced by any database object