[Home] [Help] [Dependency Information]
Object Name: | PMIBV_QC_PRODUCTION_SPEC_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PMI.PMIBV_QC_PRODUCTION_SPEC_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
QC Production Specification Full View
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QUALITY_CONTROL_SPEC_ID | NUMBER | (10) | Quality Control Spec ID | |
ASSAY_TYPE_ID | NUMBER | (15) | Assay Type ID | |
ORGANIZATION_CODE | VARCHAR2 | (4) | OPM Organization Code | |
WAREHOUSE_CODE | VARCHAR2 | (4) | OPM Warehouse Code | |
LOCATION | VARCHAR2 | (16) | Location | |
DOCUMENT_TYPE | VARCHAR2 | (4) | Document Type | |
VENDOR_SPECIFICATION | NUMBER | (5) | Vendor Specification | |
VENDOR_CERTIFICATION | NUMBER | (5) | Vendor Certification | |
CUSTOMER_SPECIFICATION | NUMBER | (5) | Customer Specification | |
CUSTOMER_CERTIFICATION | NUMBER | (5) | Customer Certification | |
ASSAY_CODE | VARCHAR2 | (16) | Assay Code | |
TEXT_SPEC | VARCHAR2 | (16) | Text Spec | |
MIN_SPEC | NUMBER | MIN Spec | ||
MAX_SPEC | NUMBER | MAX Spec | ||
TARGET_SPEC | NUMBER | Target Spec | ||
QUALITY_CONTROL_UNIT_CODE | VARCHAR2 | (4) | Quality Control Unit Code | |
FROM_DATE | DATE | From Date | ||
TO_DATE | DATE | To Date | ||
OUT_OF_ACTION_CODE | VARCHAR2 | (4) | Out Of Action Code | |
OUT_OF_ACTION_INTERVAL | NUMBER | Out Of Action Interval | ||
PREFERENCE | NUMBER | (5) | Preference | |
PRINT_COA_SHIPPED | NUMBER | (5) | Print COA Shipped | |
PRINT_COA_INVOICED | NUMBER | (5) | Print COA Invoiced | |
VENDOR_COA_REQUIRED | NUMBER | (5) | Vendor COA Required | |
DELETE_MARK | NUMBER | (5) | Delete Mark is used mark record for logical deletion | |
ROUTING_STEP_NUMBER | NUMBER | (5) | Routing Step Number | |
CUSTOMER_NUMBER | CHAR | (1) | Customer Number | |
CUSTOMER_NAME | CHAR | (1) | Customer Name | |
ITEM_NUMBER | VARCHAR2 | (32) | Item Number | |
ITEM_DESCRIPTION | VARCHAR2 | (70) | Item Description | |
VENDOR_ID | NUMBER | Vendor ID | ||
VENDOR_NUMBER | CHAR | (1) | Vendor Number | |
VENDOR_NAME | CHAR | (1) | Vendor Name | |
FORMULA_ID | NUMBER | (10) | Formula Id | |
FORMULA_NUMBER | VARCHAR2 | (32) | Formula Number | |
FORMULA_VERSION | NUMBER | Formula Version | ||
LOT_NUMBER | VARCHAR2 | (32) | Lot Number | |
SUB_LOT_NUMBER | VARCHAR2 | (32) | Sub Lot Number | |
BATCH_NUMBER | VARCHAR2 | (32) | Batch Number | |
ROUTING_ID | NUMBER | (10) | Routing Id | |
ROUTING_NUMBER | VARCHAR2 | (32) | Routing Number | |
ROUTING_VERSION | NUMBER | (5) | Routing Version | |
OPERATION_ID | NUMBER | (10) | Operation Id | |
OPERATION_NUMBER | VARCHAR2 | (16) | Operation Number | |
OPERATION_VERSION | NUMBER | (5) | Operation Version | |
EFFECTIVE | VARCHAR2 | (80) | Effective |
Cut, paste (and edit) the following text to query this object:
SELECT QUALITY_CONTROL_SPEC_ID
, ASSAY_TYPE_ID
, ORGANIZATION_CODE
, WAREHOUSE_CODE
, LOCATION
, DOCUMENT_TYPE
, VENDOR_SPECIFICATION
, VENDOR_CERTIFICATION
, CUSTOMER_SPECIFICATION
, CUSTOMER_CERTIFICATION
, ASSAY_CODE
, TEXT_SPEC
, MIN_SPEC
, MAX_SPEC
, TARGET_SPEC
, QUALITY_CONTROL_UNIT_CODE
, FROM_DATE
, TO_DATE
, OUT_OF_ACTION_CODE
, OUT_OF_ACTION_INTERVAL
, PREFERENCE
, PRINT_COA_SHIPPED
, PRINT_COA_INVOICED
, VENDOR_COA_REQUIRED
, DELETE_MARK
, ROUTING_STEP_NUMBER
, CUSTOMER_NUMBER
, CUSTOMER_NAME
, ITEM_NUMBER
, ITEM_DESCRIPTION
, VENDOR_ID
, VENDOR_NUMBER
, VENDOR_NAME
, FORMULA_ID
, FORMULA_NUMBER
, FORMULA_VERSION
, LOT_NUMBER
, SUB_LOT_NUMBER
, BATCH_NUMBER
, ROUTING_ID
, ROUTING_NUMBER
, ROUTING_VERSION
, OPERATION_ID
, OPERATION_NUMBER
, OPERATION_VERSION
, EFFECTIVE
FROM APPS.PMIBV_QC_PRODUCTION_SPEC_V;
APPS.PMIBV_QC_PRODUCTION_SPEC_V is not referenced by any database object
|
|
|