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_VW1

Object Details

Object Name:	QC_TRAN_VW1
Object Type:	VIEW
Owner:	APPS
FND Design Data:	GMD.QC_TRAN_VW1
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)	Surrogate key Id for Item
LOT_ID	NUMBER	(10)	Lot identifier
TARGET_ITEM_ID	NUMBER	(10)	Item id for target item
TARGET_LOT_ID	NUMBER	(10)	Lot identifier for target lot
COMPLETED_IND	NUMBER		Indicator for completion status
CREATION_DATE	DATE		Creation date
DOC_ID	NUMBER	(10)	Dcoument identier surrogate key
DOC_LINE	NUMBER		Line of the document
DOC_TYPE	VARCHAR2	(4)	Type of document
LINE_ID	NUMBER	(10)	Surrogate id for the document
LINE_TYPE	NUMBER		Type of line of the document
LOCATION	VARCHAR2	(16)	Location identifier for the material
OP_CODE	NUMBER	(15)	Operartion code
ORGN_CODE	VARCHAR2	(4)	Organization code
REASON_CODE	VARCHAR2	(4)	Reason code
TEXT_CODE	NUMBER	(10)	Text code for edit text
TRANS_DATE	DATE		Date of transaction
TRANS_ID	NUMBER	(10)	Surrogate key for the transaction
TRANS_QTY	NUMBER		Quantity of transaction
TRANS_QTY2	NUMBER		Quantity of transaction
TRANS_STAT	VARCHAR2	(4)	Status of transaction
TRANS_UM	VARCHAR2	(4)	Unit of measure for transaction qty
TRANS_UM2	VARCHAR2	(4)	Unit of measure for transaction qty
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_VW1;

Dependencies

[top of page]

APPS.QC_TRAN_VW1 references the following:

APPS: IC_TRAN_PND; IC_TRAN_VW1; PM_BTCH_HDR; PM_MATL_DTL; PO_RECV_DTL; PO_RECV_HDR

APPS.QC_TRAN_VW1 is not referenced by any database object