[Home] [Help] [Dependency Information]
Object Name: | PMIBV_QCRESULT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PMI.PMIBV_QCRESULT_V |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESULT_DATE | DATE | |||
RESULT | VARCHAR2 | (40) | ||
RESULTS_QCUNIT_CODE | VARCHAR2 | (4) | Yes | |
ACCEPT | NUMBER | (5) | Yes | |
CERTI_OF_ANALYSIS | NUMBER | (5) | Yes | |
TEST_PROVIDER_CODE | VARCHAR2 | (8) | ||
ASSAY_TESTER | VARCHAR2 | (30) | ||
WF_RESPONSE | VARCHAR2 | (240) | ||
ASSAY_RETEST_FLAG | NUMBER | (5) | ||
QCASSY_TYP_ID | NUMBER | (15) | Yes | |
QC_RESULT_ID | NUMBER | (10) | Yes | |
QC_SPEC_ID | NUMBER | (10) | ||
ORGN_CODE | VARCHAR2 | (4) | Yes | |
SAMPLE_ID | NUMBER | (10) | Yes | |
SAMPLE_NO | VARCHAR2 | (32) | Yes | |
SAMPLE_DESC | VARCHAR2 | (70) | ||
SAMPLE_STATUS | VARCHAR2 | (80) | Yes | |
SAMPLE_STATUS_MEANING | VARCHAR2 | (80) | ||
ASSAY_CODE | VARCHAR2 | (16) | Yes | |
ASSAY_DESC | VARCHAR2 | (40) | Yes | |
ITEM_ID | NUMBER | (10) | Yes | |
LOT_ID | NUMBER | (10) | ||
WHSE_CODE | VARCHAR2 | (4) | ||
LOCATION | VARCHAR2 | (16) | ||
FORMULA_ID | NUMBER | (10) | ||
FORMULALINE_ID | NUMBER | (10) | ||
ROUTING_ID | NUMBER | (10) | ||
ROUTINGSTEP_ID | NUMBER | (10) | ||
OPRN_ID | NUMBER | (10) | ||
CUST_ID | NUMBER | (15) | ||
SHIP_TO_SITE_ID | NUMBER | |||
VENDOR_ID | NUMBER | (10) | ||
BATCH_ID | NUMBER | (10) | ||
ROUTINGSTEP_NO | NUMBER | (5) | ||
ITEM_NUMBER | VARCHAR2 | (32) | Yes | |
ITEM_DESCRIPTION | VARCHAR2 | (70) | Yes | |
ITEM_UOM | VARCHAR2 | (4) | Yes | |
ITEM_UOM2 | VARCHAR2 | (4) | ||
DOC_TYPE | VARCHAR2 | (4) | ||
DOC_ID | NUMBER | (10) | ||
DOCLINE_ID | NUMBER | (10) | ||
CUST_SPECIFICATION | NUMBER | (5) | ||
CUST_CERTIFICATION | NUMBER | (5) | ||
VENDOR_SPECIFICATION | NUMBER | (5) | ||
VENDOR_CERTIFICATION | NUMBER | (5) | ||
TEXT_SPEC | VARCHAR2 | (16) | ||
TARGET_SPEC | NUMBER | |||
MIN_SPEC | NUMBER | |||
MAX_SPEC | NUMBER | |||
SPEC_QCUNIT_CODE | VARCHAR2 | (4) | ||
FROM_DATE | DATE | |||
TO_DATE | DATE | |||
OUTACTION_CODE | VARCHAR2 | (4) | ||
OUTACTION_INTERVAL | NUMBER | |||
PREFERENCE | NUMBER | (5) | ||
PRINT_COA_SHIPPED | NUMBER | (5) | ||
PRINT_COA_INVOICED | NUMBER | (5) | ||
VENDOR_COA_REQUIRED | NUMBER | (5) | ||
TEST_OPRN_ID | NUMBER | (10) | ||
TEST_OPRN_LINE_ID | NUMBER | (10) | ||
CUSTOMER_NO | VARCHAR2 | (30) | ||
CUSTOMER_NAME | VARCHAR2 | (360) | ||
VENDOR_NO | VARCHAR2 | (32) | ||
VENDOR_NAME | VARCHAR2 | (40) | ||
ACCEPT_ANYWAY | NUMBER | (5) | Yes | |
LOT_NO | VARCHAR2 | (32) | ||
SUBLOT_NO | VARCHAR2 | (32) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT RESULT_DATE
, RESULT
, RESULTS_QCUNIT_CODE
, ACCEPT
, CERTI_OF_ANALYSIS
, 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.PMIBV_QCRESULT_V;
APPS.PMIBV_QCRESULT_V is not referenced by any database object
|
|
|