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.QA_ERES_RCV_TRANS_INTERFACE_V

Object Details

Object Name:	QA_ERES_RCV_TRANS_INTERFACE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	QA.QA_ERES_RCV_TRANS_INTERFACE_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ID	NUMBER		Yes	txn ID
PARENT_TRANSACTION_ID	NUMBER			Parent transaction ID
ORGANIZATION_ID	NUMBER			org ID
ORGANIZATION_CODE	VARCHAR2	(3)		org code
ORGANIZATION_NAME	VARCHAR2	(240)		org name
SHIPMENT_HEADER_ID	NUMBER			shipment header ID
RECEIPT_NUMBER	VARCHAR2	(30)		receipt num
ORDER_TYPE	VARCHAR2	(25)	Yes	order type
SOURCE_DOCUMENT_CODE	VARCHAR2	(25)		source document code
ORDER_NUMBER	VARCHAR2	(40)		order num
REQUISITION_NUMBER	VARCHAR2	(20)		requisition num
ITEM_ID	NUMBER			item ID
ITEM	VARCHAR2	(40)		item num
ITEM_REVISION	VARCHAR2	(3)		item rev
ITEM_DESCRIPTION	VARCHAR2	(240)		item description
LOCATION_ID	NUMBER			location id
LOCATION	VARCHAR2	(60)		location
LOCATION_DESCRIPTION	VARCHAR2	(240)		location description
SUBINVENTORY	VARCHAR2	(10)		subinventory
LOCATOR_ID	NUMBER			locator ID
LOCATOR	CHAR	(1)		locator
TRANSACTION_QUANTITY	NUMBER			txn qty
TRANSACTION_UOM	VARCHAR2	(25)		uom
SECONDARY_QUANTITY	NUMBER			secondary qty
SECONDARY_UOM	VARCHAR2	(25)		secondary uom
DESTINATION_TYPE	VARCHAR2	(25)		destination type
RECEIPT_ROUTING_ID	NUMBER			receipt routing ID
RECEIPT_ROUTING	VARCHAR2	(80)		receipt routing
TRANSACTION_DATE	DATE		Yes	txn date
SUPPLIER_ID	NUMBER			supplier ID
SUPPLIER	VARCHAR2	(240)		supplier
SUPPLIER_LOT	VARCHAR2	(30)		supplier lot
SUPPLIER_ITEM	VARCHAR2	(25)		supplier item
CUSTOMER_ID	NUMBER			customer ID
CUSTOMER	VARCHAR2	(360)		customer
CUSTOMER_ITEM	VARCHAR2	(50)		customer_item
HAZARD_CLASS_ID	NUMBER			hazard class ID
HAZARD_CLASS	VARCHAR2	(4000)		hazard class
UN_NUMBER_ID	NUMBER			UN num ID
UN_NUMBER	VARCHAR2	(4000)		UM Num
PROJECT_NUMBER	VARCHAR2	(4000)		project
TASK_NUMBER	VARCHAR2	(4000)		task
PO_RELEASE_NUMBER	NUMBER			PO release
PO_RELEASE_LINE_NUMBER	NUMBER			PO release line
SHIPMENT_NUMBER	NUMBER			shipment
ORDERED_QUANTITY	NUMBER			ordered qty
ORDERED_UOM	VARCHAR2	(25)		ordered uom
DUE_DATE	DATE			due date
JOB_OR_SCHEDULE	VARCHAR2	(240)		job or schedule code
WIP_LINE_NUMBER	VARCHAR2	(10)		WIP Line
OPERATION_SEQUENCE	NUMBER			Op seq
DEPARTMENT	VARCHAR2	(10)		department
KANBAN_NUMBER	VARCHAR2	(30)		Kanban num
QA_COLLECTION_ID	NUMBER			collection ID
LAST_UPDATE_DATE	DATE		Yes	standard WHO column
LAST_UPDATED_BY	NUMBER		Yes	standard WHO column
LAST_UPDATE_LOGIN	NUMBER			standard WHO column
CREATION_DATE	DATE		Yes	standard WHO column
CREATED_BY	NUMBER		Yes	standard WHO column

Query Text

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


SELECT TRANSACTION_ID
,      PARENT_TRANSACTION_ID
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      SHIPMENT_HEADER_ID
,      RECEIPT_NUMBER
,      ORDER_TYPE
,      SOURCE_DOCUMENT_CODE
,      ORDER_NUMBER
,      REQUISITION_NUMBER
,      ITEM_ID
,      ITEM
,      ITEM_REVISION
,      ITEM_DESCRIPTION
,      LOCATION_ID
,      LOCATION
,      LOCATION_DESCRIPTION
,      SUBINVENTORY
,      LOCATOR_ID
,      LOCATOR
,      TRANSACTION_QUANTITY
,      TRANSACTION_UOM
,      SECONDARY_QUANTITY
,      SECONDARY_UOM
,      DESTINATION_TYPE
,      RECEIPT_ROUTING_ID
,      RECEIPT_ROUTING
,      TRANSACTION_DATE
,      SUPPLIER_ID
,      SUPPLIER
,      SUPPLIER_LOT
,      SUPPLIER_ITEM
,      CUSTOMER_ID
,      CUSTOMER
,      CUSTOMER_ITEM
,      HAZARD_CLASS_ID
,      HAZARD_CLASS
,      UN_NUMBER_ID
,      UN_NUMBER
,      PROJECT_NUMBER
,      TASK_NUMBER
,      PO_RELEASE_NUMBER
,      PO_RELEASE_LINE_NUMBER
,      SHIPMENT_NUMBER
,      ORDERED_QUANTITY
,      ORDERED_UOM
,      DUE_DATE
,      JOB_OR_SCHEDULE
,      WIP_LINE_NUMBER
,      OPERATION_SEQUENCE
,      DEPARTMENT
,      KANBAN_NUMBER
,      QA_COLLECTION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
FROM APPS.QA_ERES_RCV_TRANS_INTERFACE_V;

Dependencies

[top of page]

APPS.QA_ERES_RCV_TRANS_INTERFACE_V references the following:

APPS: HR_ALL_ORGANIZATION_UNITS_TL; HR_LOCATIONS_ALL_TL; MTL_CUSTOMER_ITEMS; MTL_ITEM_LOCATIONS_KFV; MTL_KANBAN_CARDS; MTL_PARAMETERS; MTL_SYSTEM_ITEMS; MTL_SYSTEM_ITEMS_KFV; MTL_UNITS_OF_MEASURE; OE_ORDER_HEADERS; OE_ORDER_LINES_ALL; PO_DISTRIBUTIONS_ALL; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; PO_RELEASES_ALL; PO_REQUISITION_HEADERS_ALL; PO_REQUISITION_LINES_ALL; PO_VENDORS; QA_CUSTOMERS_LOV_V; QA_ERES_PKG - show dependent code; RCV_PROJECT_GRP - show dependent code; RCV_ROUTING_HEADERS; RCV_SHIPMENT_HEADERS_V; RCV_SHIPMENT_LINES; RCV_TRANSACTIONS_INTERFACE; WIP_ENTITIES; WIP_LINES

APPS.QA_ERES_RCV_TRANS_INTERFACE_V is not referenced by any database object