DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.PMIFV_QC_SAMPLE_V

Object Details
Object Name: PMIFV_QC_SAMPLE_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPMI.PMIFV_QC_SAMPLE_V
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view

[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.PMIFV_QC_SAMPLE_V references the following:

SchemaAPPS
SynonymFM_FORM_MST
SynonymFM_OPRN_MST
SynonymFM_ROUT_DTL
SynonymFM_ROUT_HDR
SynonymFND_USER
SynonymGME_BATCH_HEADER
SynonymHZ_CUST_ACCOUNTS_ALL
SynonymHZ_PARTIES
SynonymIC_ITEM_MST
SynonymIC_LOTS_MST
SynonymPO_VEND_MST
SynonymQC_SMPL_MST

APPS.PMIFV_QC_SAMPLE_V is not referenced by any database object