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: ViewPMI.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:

SchemaAPPS
SynonymFM_FORM_MST_B
PL/SQL PackageFND_GLOBAL - show dependent code
ViewGEM_LOOKUPS
SynonymGMD_ALL_SPEC_VRS
SynonymGMD_EVENT_SPEC_DISP
SynonymGMD_OPERATIONS
SynonymGMD_RECIPES_B
SynonymGMD_ROUTINGS_B
SynonymGMD_SAMPLES
SynonymGMD_SAMPLE_SPEC_DISP
SynonymGME_BATCH_HEADER
ViewHR_OPERATING_UNITS
SynonymHZ_CUST_ACCOUNTS_ALL
SynonymHZ_CUST_SITE_USES_ALL
SynonymHZ_PARTIES
SynonymOE_ORDER_HEADERS_ALL
SynonymOE_ORDER_LINES_ALL
SynonymOE_TRANSACTION_TYPES
PL/SQL PackagePMI_SECURITY_PKG - show dependent code
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL
SynonymRCV_SHIPMENT_HEADERS
SynonymRCV_SHIPMENT_LINES

APPS.PMITS_QC_SAMPLES_V is not referenced by any database object