[Home] [Help] [Dependency Information]
Object Name: | PMIFV_QC_SAMPLE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PMI.PMIFV_QC_SAMPLE_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SAMPLE_ID | NUMBER | (10) | Yes | Surrogate ID to QC Samples |
ORGANIZATION_CODE | VARCHAR2 | (4) | Yes | OPM Organization Code |
SAMPLE_NO | VARCHAR2 | (32) | Yes | Sample Number |
SAMPLE_DESCRIPTION | VARCHAR2 | (70) | Sample Description | |
WAREHOUSE_CODE | VARCHAR2 | (4) | OPM Warehouse Code | |
LOCATION | VARCHAR2 | (16) | Location | |
SAMPLE_DATE | DATE | Yes | Sample Date | |
SAMPLED_BY | VARCHAR2 | (100) | Yes | Sampled By |
SAMPLE_QTY | NUMBER | Yes | Quantity taken for Sample | |
SAMPLE_UOM | VARCHAR2 | (4) | Yes | UOM |
DELETE_MARK | NUMBER | (5) | Yes | Delete mark used for logical deletion in OPM |
EXTERNAL_ID | VARCHAR2 | (32) | External ID | |
ITEM_NUMBER | VARCHAR2 | (32) | Yes | Item number |
ITEM_DESCRIPTION | VARCHAR2 | (70) | Yes | Item Description |
ITEM_UOM | VARCHAR2 | (4) | Yes | Item Primary UOM |
INVENTORY_TYPE | VARCHAR2 | (4) | Inventory Type | |
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) | Production Batch Number | |
CUSTOMER_NUMBER | VARCHAR2 | (30) | Customer Number | |
CUSTOMER_NAME | VARCHAR2 | (360) | Customer Name | |
VENDOR_NUMBER | VARCHAR2 | (32) | Vendor Number | |
VENDOR_NAME | VARCHAR2 | (40) | Vendor Name | |
OPERATION_ID | NUMBER | (10) | Operation Id | |
OPERATION_NUMBER | VARCHAR2 | (16) | Operation Number | |
OPERATION_VERSION | NUMBER | (5) | Operation Version | |
ROUTING_ID | NUMBER | (10) | Routing Id | |
ROUTING_NUMBER | VARCHAR2 | (32) | Routing Number | |
ROUTING_VERSION | NUMBER | (5) | Routing Version | |
ROUTING_STEP_NUMBER | NUMBER | (5) | Routing Step Number | |
CUSTOMER_ID | NUMBER | (15) | Customer ID | |
SHIP_TO_SITE_ID | NUMBER | Ship to Site ID |
Cut, paste (and edit) the following text to query this object:
SELECT SAMPLE_ID
, ORGANIZATION_CODE
, SAMPLE_NO
, SAMPLE_DESCRIPTION
, WAREHOUSE_CODE
, LOCATION
, SAMPLE_DATE
, SAMPLED_BY
, SAMPLE_QTY
, SAMPLE_UOM
, DELETE_MARK
, EXTERNAL_ID
, ITEM_NUMBER
, ITEM_DESCRIPTION
, ITEM_UOM
, INVENTORY_TYPE
, FORMULA_ID
, FORMULA_NUMBER
, FORMULA_VERSION
, LOT_NUMBER
, SUB_LOT_NUMBER
, BATCH_NUMBER
, CUSTOMER_NUMBER
, CUSTOMER_NAME
, VENDOR_NUMBER
, VENDOR_NAME
, OPERATION_ID
, OPERATION_NUMBER
, OPERATION_VERSION
, ROUTING_ID
, ROUTING_NUMBER
, ROUTING_VERSION
, ROUTING_STEP_NUMBER
, CUSTOMER_ID
, SHIP_TO_SITE_ID
FROM APPS.PMIFV_QC_SAMPLE_V;
APPS.PMIFV_QC_SAMPLE_V is not referenced by any database object
|
|
|