[Home] [Help] [Dependency Information]
Object Name: | PMIFV_QC_SPECIFICATIONS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PMI.PMIFV_QC_SPECIFICATIONS_V |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QUALITY_CONTROL_SPEC_ID | NUMBER | (10) | ||
ASSAY_TYPE_ID | NUMBER | (15) | ||
ORGANIZATION_CODE | VARCHAR2 | (4) | ||
WAREHOUSE_CODE | VARCHAR2 | (4) | ||
LOCATION | VARCHAR2 | (16) | ||
DOCUMENT_TYPE | VARCHAR2 | (4) | ||
VENDOR_SPECIFICATION | NUMBER | (5) | ||
VENDOR_CERTIFICATION | NUMBER | (5) | ||
CUSTOMER_SPECIFICATION | NUMBER | (5) | ||
CUSTOMER_CERTIFICATION | NUMBER | (5) | ||
ASSAY_CODE | VARCHAR2 | (16) | ||
TEXT_SPEC | VARCHAR2 | (16) | ||
MIN_SPEC | NUMBER | |||
MAX_SPEC | NUMBER | |||
TARGET_SPEC | NUMBER | |||
QUALITY_CONTROL_UNIT_CODE | VARCHAR2 | (4) | ||
FROM_DATE | DATE | |||
TO_DATE | DATE | |||
OUT_OF_ACTION_CODE | VARCHAR2 | (4) | ||
OUT_OF_ACTION_INTERVAL | NUMBER | |||
PREFERENCE | NUMBER | (5) | ||
PRINT_COA_SHIPPED | NUMBER | (5) | ||
PRINT_COA_INVOICED | NUMBER | (5) | ||
VENDOR_COA_REQUIRED | VARCHAR2 | (80) | ||
DELETE_MARK | NUMBER | (5) | ||
ROUTING_STEP_NUMBER | NUMBER | (5) | ||
CUSTOMER_NUMBER | VARCHAR2 | (30) | ||
CUSTOMER_NAME | VARCHAR2 | (360) | ||
ITEM_NUMBER | VARCHAR2 | (32) | ||
ITEM_DESCRIPTION | VARCHAR2 | (70) | ||
VENDOR_ID | NUMBER | (10) | ||
VENDOR_NUMBER | VARCHAR2 | (32) | ||
VENDOR_NAME | VARCHAR2 | (40) | ||
FORMULA_NUMBER | CHAR | (1) | ||
FORMULA_VERSION | NUMBER | |||
LOT_NUMBER | VARCHAR2 | (32) | ||
SUB_LOT_NUMBER | VARCHAR2 | (32) | ||
BATCH_NUMBER | CHAR | (1) | ||
ROUTING_NUMBER | CHAR | (1) | ||
ROUTING_VERSION | NUMBER | |||
OPERATION_NUMBER | CHAR | (1) | ||
OPERATION_VERSION | NUMBER | |||
EFFECTIVE | VARCHAR2 | (80) | ||
CUSTOMER_ID | NUMBER | (15) | ||
SHIP_TO_SITE_ID | NUMBER |
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_NUMBER
, FORMULA_VERSION
, LOT_NUMBER
, SUB_LOT_NUMBER
, BATCH_NUMBER
, ROUTING_NUMBER
, ROUTING_VERSION
, OPERATION_NUMBER
, OPERATION_VERSION
, EFFECTIVE
, CUSTOMER_ID
, SHIP_TO_SITE_ID
FROM APPS.PMIFV_QC_SPECIFICATIONS_V;
APPS.PMIFV_QC_SPECIFICATIONS_V is not referenced by any database object
|
|
|