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_SKIPLOT_RCV_RESULTS_V

Object Details

Object Name:	QA_SKIPLOT_RCV_RESULTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	QA.QA_SKIPLOT_RCV_RESULTS_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
INSP_LOT_ID	NUMBER		Yes	Primary key
CRITERIA_ID	NUMBER		Yes	Criteria ID
PROCESS_ID	NUMBER			PROCESS ID
PROCESS_CODE	VARCHAR2	(30)		PROCESS CODE
ORGANIZATION_ID	NUMBER			ORGANIZATION_ID
RECEIPT_DATE	DATE		Yes	Receipt Date
SOURCE_INSPECTED	VARCHAR2	(1)		Source Inspected
INSPECTION_STATUS	VARCHAR2	(80)		Inspection status
LOT_QTY	NUMBER		Yes	Lot quantity
TRANSACTED_QTY	NUMBER			Transacted Qty
INSPECTION_RESULT	VARCHAR2	(80)		Inspection result
LAST_INSP_DATE	DATE			Last inspection date
SHIPMENT_LINE_ID	NUMBER			Shipment line ID
SHIPMENT_LINE_NUM	NUMBER			Shipment line number
SHIPMENT_HEADER_ID	NUMBER			Shipment header ID
SHIPMENT_NUM	VARCHAR2	(30)		Shipment number
RECEIPT_NUM	VARCHAR2	(30)		Receipt number
VENDOR_ITEM_NUM	VARCHAR2	(25)		Vendor item code
VENDOR_LOT_NUM	VARCHAR2	(30)		Vendor lot number
ITEM	VARCHAR2	(40)		CONCATENATED SEGMENTS
ITEM_ID	NUMBER			ITEM_ID
ITEM_DESCRIPTION	VARCHAR2	(240)		Item description
ITEM_REVISION	VARCHAR2	(3)		Item revision
CATEGORY_ID	NUMBER			Item category ID
CATEGORY_DESC	VARCHAR2	(163)		Item category description
PO_HEADER_ID	NUMBER			PO header ID
PO_NUMBER	VARCHAR2	(50)		PO number
VENDOR_ID	NUMBER			Vendor Id
VENDOR_SITE_ID	NUMBER			Vendor Site Id
VENDOR_NAME	VARCHAR2	(360)		Vendor Name
VENDOR_SITE_CODE	VARCHAR2	(15)		Vendor Site Code
PO_LINE_ID	NUMBER			PO line ID
PO_LINE_NUMBER	NUMBER			PO line number
OE_ORDER_HEADER_ID	NUMBER			Sales Order header ID
SALES_ORDER	VARCHAR2	(4000)		Sales order
MANUFACTURER_ID	NUMBER			Manufacturer ID
MANUFACTURER_NAME	VARCHAR2	(30)		Manufacturer name
PROJECT_ID	NUMBER			Project ID
PROJECT_NUMBER	VARCHAR2	(4000)		Project number
TASK_ID	NUMBER			Task ID
TASK_NUMBER	VARCHAR2	(25)		Task number
LPN_ID	NUMBER			LPN ID
LPN	VARCHAR2	(30)		LPN
LAST_UPDATE_DATE	DATE		Yes	STD WHO COLUMN
LAST_UPDATED_BY	NUMBER		Yes	STD WHO COLUMN
CREATION_DATE	DATE		Yes	STD WHO COLUMN
CREATED_BY	NUMBER		Yes	STD WHO COLUMN
LAST_UPDATE_LOGIN	NUMBER			STD WHO COLUMN

Query Text

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


SELECT INSP_LOT_ID
,      CRITERIA_ID
,      PROCESS_ID
,      PROCESS_CODE
,      ORGANIZATION_ID
,      RECEIPT_DATE
,      SOURCE_INSPECTED
,      INSPECTION_STATUS
,      LOT_QTY
,      TRANSACTED_QTY
,      INSPECTION_RESULT
,      LAST_INSP_DATE
,      SHIPMENT_LINE_ID
,      SHIPMENT_LINE_NUM
,      SHIPMENT_HEADER_ID
,      SHIPMENT_NUM
,      RECEIPT_NUM
,      VENDOR_ITEM_NUM
,      VENDOR_LOT_NUM
,      ITEM
,      ITEM_ID
,      ITEM_DESCRIPTION
,      ITEM_REVISION
,      CATEGORY_ID
,      CATEGORY_DESC
,      PO_HEADER_ID
,      PO_NUMBER
,      VENDOR_ID
,      VENDOR_SITE_ID
,      VENDOR_NAME
,      VENDOR_SITE_CODE
,      PO_LINE_ID
,      PO_LINE_NUMBER
,      OE_ORDER_HEADER_ID
,      SALES_ORDER
,      MANUFACTURER_ID
,      MANUFACTURER_NAME
,      PROJECT_ID
,      PROJECT_NUMBER
,      TASK_ID
,      TASK_NUMBER
,      LPN_ID
,      LPN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM APPS.QA_SKIPLOT_RCV_RESULTS_V;

Dependencies

[top of page]

APPS.QA_SKIPLOT_RCV_RESULTS_V references the following:

APPS: AP_SUPPLIERS; AP_SUPPLIER_SITES_ALL; HZ_PARTIES; MTL_CATEGORIES_KFV; MTL_MANUFACTURERS; MTL_SYSTEM_ITEMS_KFV; PA_TASKS; PO_CLM_INTG_GRP - show dependent code; PO_DISTRIBUTIONS_TRX_V; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; QA_FLEX_UTIL - show dependent code; QA_LOOKUPS; QA_SKIPLOT_PROCESSES; QA_SKIPLOT_RCV_RESULTS; RCV_SHIPMENT_HEADERS; RCV_SHIPMENT_LINES; WMS_LICENSE_PLATE_NUMBERS

APPS.QA_SKIPLOT_RCV_RESULTS_V is not referenced by any database object