[Home] [Help] [Dependency Information]
Object Name: | PMIFV_QCRESULT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PMI.PMIFV_QCRESULT_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESULT_DATE | DATE | Result posted date | ||
RESULT | VARCHAR2 | (80) | Result | |
RESULTS_QCUNIT_CODE | VARCHAR2 | (25) | Result Quality Control Unit Code | |
ACCEPT | VARCHAR2 | (1) | Accept | |
FINAL_MARK | VARCHAR2 | (1) | Final Mark | |
TEST_PROVIDER_CODE | VARCHAR2 | (8) | Test Provider Code | |
ASSAY_TESTER | VARCHAR2 | (30) | Assay Tester | |
WF_RESPONSE | VARCHAR2 | (1) | Workflow Response | |
ASSAY_RETEST_FLAG | NUMBER | (8) | Retest Flag | |
QCASSY_TYP_ID | NUMBER | Assay Type ID | ||
QC_RESULT_ID | NUMBER | Result ID | ||
QC_SPEC_ID | NUMBER | Spec ID | ||
ORGN_CODE | VARCHAR2 | (4) | Organization Code | |
SAMPLE_ID | NUMBER | Sample ID | ||
SAMPLE_NO | VARCHAR2 | (80) | Sample Number | |
SAMPLE_DESC | VARCHAR2 | (80) | Sample Description | |
SAMPLE_STATUS | VARCHAR2 | (30) | Sample Status | |
SAMPLE_STATUS_MEANING | VARCHAR2 | (80) | Sample Status meaning | |
ASSAY_CODE | VARCHAR2 | (80) | Assay Code | |
ASSAY_DESC | VARCHAR2 | (240) | Assay Description | |
ITEM_ID | NUMBER | Item ID | ||
LOT_ID | NUMBER | Lot ID | ||
WHSE_CODE | VARCHAR2 | (4) | Warehouse | |
LOCATION | VARCHAR2 | (16) | Location | |
FORMULA_ID | NUMBER | Formula ID | ||
FORMULALINE_ID | NUMBER | Formula Line ID | ||
ROUTING_ID | NUMBER | Routing ID | ||
ROUTINGSTEP_ID | NUMBER | Routing Step ID | ||
OPRN_ID | NUMBER | Operation ID | ||
CUST_ID | NUMBER | Customer ID | ||
SHIP_TO_SITE_ID | NUMBER | |||
VENDOR_ID | NUMBER | Vendor ID | ||
BATCH_ID | NUMBER | Batch ID | ||
ROUTINGSTEP_NO | NUMBER | Routing Step Number | ||
ITEM_NUMBER | VARCHAR2 | (32) | Item Number | |
ITEM_DESCRIPTION | VARCHAR2 | (70) | Item Description | |
ITEM_UOM | VARCHAR2 | (4) | Primary UOM | |
ITEM_UOM2 | VARCHAR2 | (4) | Secondary UOM | |
DOC_TYPE | VARCHAR2 | (0) | Document Type | |
DOC_ID | VARCHAR2 | (0) | Document ID | |
DOCLINE_ID | VARCHAR2 | (0) | Document Line ID | |
CUST_SPECIFICATION | VARCHAR2 | (0) | Customer Specification | |
CUST_CERTIFICATION | VARCHAR2 | (0) | Customer Certification | |
VENDOR_SPECIFICATION | VARCHAR2 | (0) | Vendor Specification | |
VENDOR_CERTIFICATION | VARCHAR2 | (0) | Vendor Certification | |
TEXT_SPEC | VARCHAR2 | (16) | Text Spec | |
TARGET_SPEC | VARCHAR2 | (40) | Target Spec | |
MIN_SPEC | VARCHAR2 | (40) | Min Spec | |
MAX_SPEC | VARCHAR2 | (40) | Max Spec | |
SPEC_QCUNIT_CODE | VARCHAR2 | (25) | Spec Quality Control Unit Code | |
FROM_DATE | DATE | From Date | ||
TO_DATE | DATE | To Date | ||
OUTACTION_CODE | VARCHAR2 | (32) | Out Of Action Code | |
OUTACTION_INTERVAL | NUMBER | Out Of Action Interval | ||
PREFERENCE | VARCHAR2 | (0) | Preference | |
PRINT_COA_SHIPPED | VARCHAR2 | (1) | To Indentify whether Certificate of Analysis need to be sent with shipment Flag | |
PRINT_COA_INVOICED | VARCHAR2 | (1) | Print Certificate of Analysis Flag | |
VENDOR_COA_REQUIRED | VARCHAR2 | (1) | Vendor Certificate of Analysis Required Flag | |
TEST_OPRN_ID | NUMBER | Test Operation ID | ||
TEST_OPRN_LINE_ID | NUMBER | Test Operation Line ID | ||
CUSTOMER_NO | VARCHAR2 | (30) | Customer Number | |
CUSTOMER_NAME | VARCHAR2 | (360) | Customer Name | |
VENDOR_NO | VARCHAR2 | (32) | VEndor Number | |
VENDOR_NAME | VARCHAR2 | (40) | Vendor Name | |
ACCEPT_ANYWAY | VARCHAR2 | (1) | Accept Anyway | |
LOT_NO | VARCHAR2 | (32) | Lot Number | |
SUBLOT_NO | VARCHAR2 | (32) | Sublot Number | |
CREATED_BY | NUMBER | (15) | ROW WHO Column | |
CREATION_DATE | DATE | ROW WHO Column | ||
LAST_UPDATE_DATE | DATE | ROW WHO Column | ||
LAST_UPDATED_BY | NUMBER | (15) | ROW WHO Column |
Cut, paste (and edit) the following text to query this object:
SELECT RESULT_DATE
, RESULT
, RESULTS_QCUNIT_CODE
, ACCEPT
, FINAL_MARK
, TEST_PROVIDER_CODE
, ASSAY_TESTER
, WF_RESPONSE
, ASSAY_RETEST_FLAG
, QCASSY_TYP_ID
, QC_RESULT_ID
, QC_SPEC_ID
, ORGN_CODE
, SAMPLE_ID
, SAMPLE_NO
, SAMPLE_DESC
, SAMPLE_STATUS
, SAMPLE_STATUS_MEANING
, ASSAY_CODE
, ASSAY_DESC
, ITEM_ID
, LOT_ID
, WHSE_CODE
, LOCATION
, FORMULA_ID
, FORMULALINE_ID
, ROUTING_ID
, ROUTINGSTEP_ID
, OPRN_ID
, CUST_ID
, SHIP_TO_SITE_ID
, VENDOR_ID
, BATCH_ID
, ROUTINGSTEP_NO
, ITEM_NUMBER
, ITEM_DESCRIPTION
, ITEM_UOM
, ITEM_UOM2
, DOC_TYPE
, DOC_ID
, DOCLINE_ID
, CUST_SPECIFICATION
, CUST_CERTIFICATION
, VENDOR_SPECIFICATION
, VENDOR_CERTIFICATION
, TEXT_SPEC
, TARGET_SPEC
, MIN_SPEC
, MAX_SPEC
, SPEC_QCUNIT_CODE
, FROM_DATE
, TO_DATE
, OUTACTION_CODE
, OUTACTION_INTERVAL
, PREFERENCE
, PRINT_COA_SHIPPED
, PRINT_COA_INVOICED
, VENDOR_COA_REQUIRED
, TEST_OPRN_ID
, TEST_OPRN_LINE_ID
, CUSTOMER_NO
, CUSTOMER_NAME
, VENDOR_NO
, VENDOR_NAME
, ACCEPT_ANYWAY
, LOT_NO
, SUBLOT_NO
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
FROM APPS.PMIFV_QCRESULT_V;
APPS.PMIFV_QCRESULT_V is not referenced by any database object
|
|
|