[Home] [Help] [Dependency Information]
Object Name: | PMIFV_BTCH_QCRSLT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PMI.PMIFV_BTCH_QCRSLT_V |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Batch QC Results
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CO_CODE | VARCHAR2 | (4) | ||
ORGN_CODE | VARCHAR2 | (4) | ||
WHSE_CODE | VARCHAR2 | (4) | ||
ACTUAL_CMPLT_DATE | DATE | |||
SAMPLE_ID | NUMBER | |||
SAMPLE_NO | VARCHAR2 | (80) | ||
SAMPLE_DESC | VARCHAR2 | (80) | ||
SAMPLE_STATUS | VARCHAR2 | (3) | ||
SAMPLE_STATUS_MEANING | VARCHAR2 | (80) | Sample Status Meaning | |
ASSAY_CODE | VARCHAR2 | (80) | ||
RESULT_DATE | DATE | |||
RESULT | VARCHAR2 | (80) | ||
TEXT_SPEC | VARCHAR2 | (16) | ||
TARGET_SPEC | VARCHAR2 | (40) | ||
MIN_SPEC | VARCHAR2 | (40) | ||
MAX_SPEC | VARCHAR2 | (40) | ||
RESULTS_QCUNIT_CODE | VARCHAR2 | (25) | ||
ACCEPT | VARCHAR2 | (1) | ||
ITEM_ID | NUMBER | |||
ITEM_NUMBER | VARCHAR2 | (32) | ||
ITEM_DESCRIPTION | VARCHAR2 | (70) | ||
BATCH_ID | NUMBER | |||
BATCH_NO | VARCHAR2 | (32) | ||
BATCH_ADJUSTED | NUMBER | |||
ROUTING_ID | NUMBER | |||
ROUTING_NO | VARCHAR2 | (32) | ||
ROUTING_VERS | NUMBER | (5) | ||
ROUTINGSTEP_ID | NUMBER | |||
ROUTINGSTEP_NO | NUMBER | |||
OPRN_ID | NUMBER | |||
OPERATION_NO | VARCHAR2 | (16) | ||
FISCAL_YEAR | NUMBER | (15) | ||
PERIOD_CODE | NUMBER | (15) | ||
PERIOD_NAME | VARCHAR2 | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT CO_CODE
, ORGN_CODE
, WHSE_CODE
, ACTUAL_CMPLT_DATE
, SAMPLE_ID
, SAMPLE_NO
, SAMPLE_DESC
, SAMPLE_STATUS
, SAMPLE_STATUS_MEANING
, ASSAY_CODE
, RESULT_DATE
, RESULT
, TEXT_SPEC
, TARGET_SPEC
, MIN_SPEC
, MAX_SPEC
, RESULTS_QCUNIT_CODE
, ACCEPT
, ITEM_ID
, ITEM_NUMBER
, ITEM_DESCRIPTION
, BATCH_ID
, BATCH_NO
, BATCH_ADJUSTED
, ROUTING_ID
, ROUTING_NO
, ROUTING_VERS
, ROUTINGSTEP_ID
, ROUTINGSTEP_NO
, OPRN_ID
, OPERATION_NO
, FISCAL_YEAR
, PERIOD_CODE
, PERIOD_NAME
FROM APPS.PMIFV_BTCH_QCRSLT_V;
APPS.PMIFV_BTCH_QCRSLT_V is not referenced by any database object
|
|
|