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

Object Details

Object Name:	PMITS_QC_SAMPLES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PMI.PMITS_QC_SAMPLES_V
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SAMPLING_EVENT_ID	NUMBER		Yes	Unique Identifier for Sampling Event
STEP_NO	NUMBER			Step Number
STEP_ID	NUMBER			Unique Identifier for Step
SAMPLE_ID	NUMBER		Yes	Unique Identifier for Sample
SAMPLE_NO	VARCHAR2	(80)	Yes	Sample Number
SAMPLE_DESC	VARCHAR2	(80)		Sample Description
QC_LAB_ORGN_CODE	VARCHAR2	(4)		LAB Organization Code
ITEM_ID	NUMBER			Unique Identifier for Item
LOCATION	VARCHAR2	(16)		Location
EXPIRATION_DATE	DATE			Expiration Date
LOT_ID	NUMBER			Unique Identifier for Lot
LOT_NO	VARCHAR2	(32)		Lot Number
BATCH_ID	NUMBER			Unique Identifier for Production Batch
RECIPE_ID	NUMBER			Unique Identifier for Recipe
FORMULA_ID	NUMBER			Unique Identifier for Formula
FORMULALINE_ID	NUMBER			Unique Identifier for Formula Line
ROUTING_ID	NUMBER			Unique Identifier for Routing
OPRN_ID	NUMBER			Unique Identifier for Operation
CHARGE	NUMBER			Charge
CUST_ID	NUMBER			Unique Identifier for Customer
ORDER_ID	NUMBER			Unique Identifier for Sales Order
ORDER_LINE_ID	NUMBER			Unique Identifier for Sales Order Line
ORG_ID	NUMBER			Unique Identifier for Operating Unit
SUPPLIER_ID	NUMBER			Unique Identifier for Supplier
SAMPLE_QTY	NUMBER			Sample Qty
SAMPLE_UOM	VARCHAR2	(4)		Sample UOM
SOURCE	VARCHAR2	(1)	Yes	Sample Source
SOURCE_DISP	VARCHAR2	(80)	Yes	Sample Source Meaning W-WIP, I-Inventory,C-Customer and S-Supplier
SAMPLER_ID	NUMBER		Yes	Sample Take by
DATE_DRAWN	DATE			Sample Drawn On
SOURCE_COMMENT	VARCHAR2	(1024)		Source Comment
STORAGE_WHSE	VARCHAR2	(4)		Storage warehouse
STORAGE_LOCATION	VARCHAR2	(16)		Storage Location
EXTERNAL_ID	VARCHAR2	(32)		External ID
SAMPLE_APPROVER_ID	VARCHAR2	(30)		Sample Approver
INV_APPROVER_ID	VARCHAR2	(30)		Inventory Approver
PRIORITY	VARCHAR2	(2)		Priority
SAMPLE_INV_TRANS_IND	VARCHAR2	(1)		Update Inventory Qty Indicator
SAMPLE_INV_TRANS_IND_DISP	VARCHAR2	(80)		Update Inventory Qty Indicator Meaning
DELETE_MARK	NUMBER	(5)	Yes	Marked for Purge
DELETE_MARK_DISP	VARCHAR2	(80)		0-No, 1-Yes
SUPPLIER_SITE_ID	NUMBER			Unique Identifier for Supplier Site
WHSE_CODE	VARCHAR2	(4)		Warehouse Code
ORGN_CODE	VARCHAR2	(4)		Organization Code
PO_HEADER_ID	NUMBER			Unique Identifier for Purchase order Header
PO_LINE_ID	NUMBER			Unique Identifier for Purchase Order Line
RECEIPT_ID	NUMBER			Unique Identifier for Receipt
RECEIPT_LINE_ID	NUMBER			Unique Identifier for Receipt Line
SHIP_TO_SITE_ID	NUMBER			Unique Identifier for Ship to Site
SUPPLIER_LOT_NO	VARCHAR2	(32)		Supplier Lot Number
LOT_RETEST_IND	VARCHAR2	(1)		Lot Retest Indicator
SAMPLE_INSTANCE	NUMBER			Sample Instance. This need be looked at in conjunction with Sampling Events Number of Samples
SUBLOT_NO	VARCHAR2	(32)		Sublot Number
SUPPLIER_CODE	VARCHAR2	(30)		Supplier Code
SUPPLIER_NAME	VARCHAR2	(240)		Supplier name
SUPPLIER_SITE	VARCHAR2	(15)		Supplier Site
PO_NUMBER	VARCHAR2	(20)		Purchase Order Number
PO_LINE_NUMBER	NUMBER			Purchase Order Line number
RECEIPT_NUMBER	VARCHAR2	(30)		Receipt Number
RECEIPT_LINE_NUMBER	NUMBER			Receipt Line
CUSTOMER_NAME	VARCHAR2	(360)		Customer Name
OPERATING_UNIT_NAME	VARCHAR2	(240)		Operating Unit Name
SHIP_TO_SITE_NAME	VARCHAR2	(40)		Ship to Site Name
ORDER_NUMBER	NUMBER			Sales Order Number
ORDER_TYPE	VARCHAR2	(30)		Sales Order Type
ORDER_LINE_NUMBER	NUMBER			Sales Order Line Number
BATCH_NO	VARCHAR2	(32)		Production Batch Number
PLANT_CODE	VARCHAR2	(4)		Plant Code
FORMULA_NO	VARCHAR2	(32)		Formula Number
FORMULA_VERS	NUMBER			Formula Version
OPRN_NO	VARCHAR2	(16)		Operation Number
OPRN_VERS	NUMBER	(5)		Operation Version
RECIPE_NO	VARCHAR2	(32)		Recipe Number
RECIPE_VERSION	NUMBER	(5)		Recipe version
ROUTING_NO	VARCHAR2	(32)		Routing Number
ROUTING_VERS	NUMBER	(5)		Routing Version
SAMPLE_SPEC_DISPOSITION	VARCHAR2	(80)	Yes	Sample Spec Disposition
SPEC_NAME	VARCHAR2	(80)		Sapec Name
SPEC_VERS	NUMBER	(10)		Spec Version
SPEC_USED_FOR_LOT_ATTRIB_IND	VARCHAR2	(1)		Current Spec Results used to set Lot Attributes

Query Text

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


SELECT SAMPLING_EVENT_ID
,      STEP_NO
,      STEP_ID
,      SAMPLE_ID
,      SAMPLE_NO
,      SAMPLE_DESC
,      QC_LAB_ORGN_CODE
,      ITEM_ID
,      LOCATION
,      EXPIRATION_DATE
,      LOT_ID
,      LOT_NO
,      BATCH_ID
,      RECIPE_ID
,      FORMULA_ID
,      FORMULALINE_ID
,      ROUTING_ID
,      OPRN_ID
,      CHARGE
,      CUST_ID
,      ORDER_ID
,      ORDER_LINE_ID
,      ORG_ID
,      SUPPLIER_ID
,      SAMPLE_QTY
,      SAMPLE_UOM
,      SOURCE
,      SOURCE_DISP
,      SAMPLER_ID
,      DATE_DRAWN
,      SOURCE_COMMENT
,      STORAGE_WHSE
,      STORAGE_LOCATION
,      EXTERNAL_ID
,      SAMPLE_APPROVER_ID
,      INV_APPROVER_ID
,      PRIORITY
,      SAMPLE_INV_TRANS_IND
,      SAMPLE_INV_TRANS_IND_DISP
,      DELETE_MARK
,      DELETE_MARK_DISP
,      SUPPLIER_SITE_ID
,      WHSE_CODE
,      ORGN_CODE
,      PO_HEADER_ID
,      PO_LINE_ID
,      RECEIPT_ID
,      RECEIPT_LINE_ID
,      SHIP_TO_SITE_ID
,      SUPPLIER_LOT_NO
,      LOT_RETEST_IND
,      SAMPLE_INSTANCE
,      SUBLOT_NO
,      SUPPLIER_CODE
,      SUPPLIER_NAME
,      SUPPLIER_SITE
,      PO_NUMBER
,      PO_LINE_NUMBER
,      RECEIPT_NUMBER
,      RECEIPT_LINE_NUMBER
,      CUSTOMER_NAME
,      OPERATING_UNIT_NAME
,      SHIP_TO_SITE_NAME
,      ORDER_NUMBER
,      ORDER_TYPE
,      ORDER_LINE_NUMBER
,      BATCH_NO
,      PLANT_CODE
,      FORMULA_NO
,      FORMULA_VERS
,      OPRN_NO
,      OPRN_VERS
,      RECIPE_NO
,      RECIPE_VERSION
,      ROUTING_NO
,      ROUTING_VERS
,      SAMPLE_SPEC_DISPOSITION
,      SPEC_NAME
,      SPEC_VERS
,      SPEC_USED_FOR_LOT_ATTRIB_IND
FROM APPS.PMITS_QC_SAMPLES_V;

Dependencies

[top of page]

APPS.PMITS_QC_SAMPLES_V references the following:

APPS: FM_FORM_MST_B; FND_GLOBAL - show dependent code; GEM_LOOKUPS; GMD_ALL_SPEC_VRS; GMD_EVENT_SPEC_DISP; GMD_OPERATIONS; GMD_RECIPES_B; GMD_ROUTINGS_B; GMD_SAMPLES; GMD_SAMPLE_SPEC_DISP; GME_BATCH_HEADER; HR_OPERATING_UNITS; HZ_CUST_ACCOUNTS_ALL; HZ_CUST_SITE_USES_ALL; HZ_PARTIES; OE_ORDER_HEADERS_ALL; OE_ORDER_LINES_ALL; OE_TRANSACTION_TYPES; PMI_SECURITY_PKG - show dependent code; PO_HEADERS_ALL; PO_LINES_ALL; PO_VENDORS; PO_VENDOR_SITES_ALL; RCV_SHIPMENT_HEADERS; RCV_SHIPMENT_LINES

APPS.PMITS_QC_SAMPLES_V is not referenced by any database object