[Home] [Help] [Dependency Information]
Object Name: | PMITS_QC_SAMPLES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PMI.PMITS_QC_SAMPLES_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SAMPLING_EVENT_ID | NUMBER | Yes | Unique Identifier for Sampling Event | |
STEP_NO | NUMBER | Step Number | ||
STEP_ID | NUMBER | Unique Identifier for Step | ||
SAMPLE_ID | NUMBER | Yes | Unique Identifier for Sample | |
SAMPLE_NO | VARCHAR2 | (80) | Yes | Sample Number |
SAMPLE_DESC | VARCHAR2 | (80) | Sample Description | |
QC_LAB_ORGN_CODE | VARCHAR2 | (4) | LAB Organization Code | |
ITEM_ID | NUMBER | Unique Identifier for Item | ||
LOCATION | VARCHAR2 | (16) | Location | |
EXPIRATION_DATE | DATE | Expiration Date | ||
LOT_ID | NUMBER | Unique Identifier for Lot | ||
LOT_NO | VARCHAR2 | (32) | Lot Number | |
BATCH_ID | NUMBER | Unique Identifier for Production Batch | ||
RECIPE_ID | NUMBER | Unique Identifier for Recipe | ||
FORMULA_ID | NUMBER | Unique Identifier for Formula | ||
FORMULALINE_ID | NUMBER | Unique Identifier for Formula Line | ||
ROUTING_ID | NUMBER | Unique Identifier for Routing | ||
OPRN_ID | NUMBER | Unique Identifier for Operation | ||
CHARGE | NUMBER | Charge | ||
CUST_ID | NUMBER | Unique Identifier for Customer | ||
ORDER_ID | NUMBER | Unique Identifier for Sales Order | ||
ORDER_LINE_ID | NUMBER | Unique Identifier for Sales Order Line | ||
ORG_ID | NUMBER | Unique Identifier for Operating Unit | ||
SUPPLIER_ID | NUMBER | Unique Identifier for Supplier | ||
SAMPLE_QTY | NUMBER | Sample Qty | ||
SAMPLE_UOM | VARCHAR2 | (4) | Sample UOM | |
SOURCE | VARCHAR2 | (1) | Yes | Sample Source |
SOURCE_DISP | VARCHAR2 | (80) | Yes | Sample Source Meaning W-WIP, I-Inventory,C-Customer and S-Supplier |
SAMPLER_ID | NUMBER | Yes | Sample Take by | |
DATE_DRAWN | DATE | Sample Drawn On | ||
SOURCE_COMMENT | VARCHAR2 | (1024) | Source Comment | |
STORAGE_WHSE | VARCHAR2 | (4) | Storage warehouse | |
STORAGE_LOCATION | VARCHAR2 | (16) | Storage Location | |
EXTERNAL_ID | VARCHAR2 | (32) | External ID | |
SAMPLE_APPROVER_ID | VARCHAR2 | (30) | Sample Approver | |
INV_APPROVER_ID | VARCHAR2 | (30) | Inventory Approver | |
PRIORITY | VARCHAR2 | (2) | Priority | |
SAMPLE_INV_TRANS_IND | VARCHAR2 | (1) | Update Inventory Qty Indicator | |
SAMPLE_INV_TRANS_IND_DISP | VARCHAR2 | (80) | Update Inventory Qty Indicator Meaning | |
DELETE_MARK | NUMBER | (5) | Yes | Marked for Purge |
DELETE_MARK_DISP | VARCHAR2 | (80) | 0-No, 1-Yes | |
SUPPLIER_SITE_ID | NUMBER | Unique Identifier for Supplier Site | ||
WHSE_CODE | VARCHAR2 | (4) | Warehouse Code | |
ORGN_CODE | VARCHAR2 | (4) | Organization Code | |
PO_HEADER_ID | NUMBER | Unique Identifier for Purchase order Header | ||
PO_LINE_ID | NUMBER | Unique Identifier for Purchase Order Line | ||
RECEIPT_ID | NUMBER | Unique Identifier for Receipt | ||
RECEIPT_LINE_ID | NUMBER | Unique Identifier for Receipt Line | ||
SHIP_TO_SITE_ID | NUMBER | Unique Identifier for Ship to Site | ||
SUPPLIER_LOT_NO | VARCHAR2 | (32) | Supplier Lot Number | |
LOT_RETEST_IND | VARCHAR2 | (1) | Lot Retest Indicator | |
SAMPLE_INSTANCE | NUMBER | Sample Instance. This need be looked at in conjunction with Sampling Events Number of Samples | ||
SUBLOT_NO | VARCHAR2 | (32) | Sublot Number | |
SUPPLIER_CODE | VARCHAR2 | (30) | Supplier Code | |
SUPPLIER_NAME | VARCHAR2 | (240) | Supplier name | |
SUPPLIER_SITE | VARCHAR2 | (15) | Supplier Site | |
PO_NUMBER | VARCHAR2 | (20) | Purchase Order Number | |
PO_LINE_NUMBER | NUMBER | Purchase Order Line number | ||
RECEIPT_NUMBER | VARCHAR2 | (30) | Receipt Number | |
RECEIPT_LINE_NUMBER | NUMBER | Receipt Line | ||
CUSTOMER_NAME | VARCHAR2 | (360) | Customer Name | |
OPERATING_UNIT_NAME | VARCHAR2 | (240) | Operating Unit Name | |
SHIP_TO_SITE_NAME | VARCHAR2 | (40) | Ship to Site Name | |
ORDER_NUMBER | NUMBER | Sales Order Number | ||
ORDER_TYPE | VARCHAR2 | (30) | Sales Order Type | |
ORDER_LINE_NUMBER | NUMBER | Sales Order Line Number | ||
BATCH_NO | VARCHAR2 | (32) | Production Batch Number | |
PLANT_CODE | VARCHAR2 | (4) | Plant Code | |
FORMULA_NO | VARCHAR2 | (32) | Formula Number | |
FORMULA_VERS | NUMBER | Formula Version | ||
OPRN_NO | VARCHAR2 | (16) | Operation Number | |
OPRN_VERS | NUMBER | (5) | Operation Version | |
RECIPE_NO | VARCHAR2 | (32) | Recipe Number | |
RECIPE_VERSION | NUMBER | (5) | Recipe version | |
ROUTING_NO | VARCHAR2 | (32) | Routing Number | |
ROUTING_VERS | NUMBER | (5) | Routing Version | |
SAMPLE_SPEC_DISPOSITION | VARCHAR2 | (80) | Yes | Sample Spec Disposition |
SPEC_NAME | VARCHAR2 | (80) | Sapec Name | |
SPEC_VERS | NUMBER | (10) | Spec Version | |
SPEC_USED_FOR_LOT_ATTRIB_IND | VARCHAR2 | (1) | Current Spec Results used to set Lot Attributes |
Cut, paste (and edit) the following text to query this object:
SELECT SAMPLING_EVENT_ID
, STEP_NO
, STEP_ID
, SAMPLE_ID
, SAMPLE_NO
, SAMPLE_DESC
, QC_LAB_ORGN_CODE
, ITEM_ID
, LOCATION
, EXPIRATION_DATE
, LOT_ID
, LOT_NO
, BATCH_ID
, RECIPE_ID
, FORMULA_ID
, FORMULALINE_ID
, ROUTING_ID
, OPRN_ID
, CHARGE
, CUST_ID
, ORDER_ID
, ORDER_LINE_ID
, ORG_ID
, SUPPLIER_ID
, SAMPLE_QTY
, SAMPLE_UOM
, SOURCE
, SOURCE_DISP
, SAMPLER_ID
, DATE_DRAWN
, SOURCE_COMMENT
, STORAGE_WHSE
, STORAGE_LOCATION
, EXTERNAL_ID
, SAMPLE_APPROVER_ID
, INV_APPROVER_ID
, PRIORITY
, SAMPLE_INV_TRANS_IND
, SAMPLE_INV_TRANS_IND_DISP
, DELETE_MARK
, DELETE_MARK_DISP
, SUPPLIER_SITE_ID
, WHSE_CODE
, ORGN_CODE
, PO_HEADER_ID
, PO_LINE_ID
, RECEIPT_ID
, RECEIPT_LINE_ID
, SHIP_TO_SITE_ID
, SUPPLIER_LOT_NO
, LOT_RETEST_IND
, SAMPLE_INSTANCE
, SUBLOT_NO
, SUPPLIER_CODE
, SUPPLIER_NAME
, SUPPLIER_SITE
, PO_NUMBER
, PO_LINE_NUMBER
, RECEIPT_NUMBER
, RECEIPT_LINE_NUMBER
, CUSTOMER_NAME
, OPERATING_UNIT_NAME
, SHIP_TO_SITE_NAME
, ORDER_NUMBER
, ORDER_TYPE
, ORDER_LINE_NUMBER
, BATCH_NO
, PLANT_CODE
, FORMULA_NO
, FORMULA_VERS
, OPRN_NO
, OPRN_VERS
, RECIPE_NO
, RECIPE_VERSION
, ROUTING_NO
, ROUTING_VERS
, SAMPLE_SPEC_DISPOSITION
, SPEC_NAME
, SPEC_VERS
, SPEC_USED_FOR_LOT_ATTRIB_IND
FROM APPS.PMITS_QC_SAMPLES_V;
APPS.PMITS_QC_SAMPLES_V is not referenced by any database object
|
|
|