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

VIEW: APPS.PMITS_QC_ALL_SPEC_VRS_V

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

View Type

A Business Intelligence System view

[View Source]

Columns
Name Datatype Length Mandatory Comments
SPEC_VR_ID NUMBER

Unique Identifier for Spec Validity Rule
SPEC_ID NUMBER

Unique Identifier for Spec
ORGN_CODE CHAR (3)
Organization
SPEC_TYPE CHAR (1)
Spec Type Code W-WIP, C-Customer, S-Supplier and I-Inventory
SPEC_TYPE_DISP CHAR (3)
Spec Type Meaning Resolved using GEM_LOOKUPS
SPEC_NAME CHAR (3)
Spec Name
SPEC_VERS NUMBER

Spec Version
ITEM_ID NUMBER

Unique Identifier Item
ITEM_NO CHAR (3)
ItemNumber
GRADE CHAR (3)
Quality Control Grade
SPEC_STATUS NUMBER

Spec Status Code
SPEC_STATUS_DESC CHAR (3)
Spec Status Meaning Resolved using GEM_LOOKUPS
LOT_ID NUMBER

Unique Identifier Lot
LOT_NO CHAR (3)
Lot Number
SUBLOT_NO CHAR (3)
Sublot Number
WHSE_CODE CHAR (3)
Warehouse Code
LOCATION CHAR (3)
Location
SPEC_VR_STATUS NUMBER

Spec Validity Rule Status Code
SPEC_VR_STATUS_DESC CHAR (3)
Spec Validity Rule Status Meaning Resolved using GEM_LOOKUPS
START_DATE DATE

Start Date
END_DATE DATE

End date
SAMPLING_PLAN_ID NUMBER

Sampling Plan ID
SAMPLE_INV_TRANS_IND CHAR (1)
Update Inventory Qty Indicator
SAMPLE_INV_TRANS_IND_DISP CHAR (3)
Update Inventory Qty Indicator Meaning Resolved using GEM_LOOKUPS
CONTROL_LOT_ATTRIB_IND CHAR (1)
Control Lot Status Code
CONTROL_LOT_ATTRIB_IND_DISP CHAR (3)
Control Lot Status Meaning Resolved using GEM_LOOKUPS
OUT_OF_SPEC_LOT_STATUS CHAR (3)
Out of Spec Lot Status
IN_SPEC_LOT_STATUS CHAR (3)
In Spec Lot Status
CONTROL_BATCH_STEP_IND CHAR (1)
Control Batch Step Status
CONTROL_BATCH_STEP_IND_DISP CHAR (3)
Control Batch Step Status Meaning Resolved using GEM_LOOKUPS
LOT_OPTIONAL_ON_SAMPLE CHAR (1)
Lot Optional on sample
COA_TYPE CHAR (1)
Certificate Type
COA_TYPE_DISP CHAR (3)
Certificate Type Meaning Resolved using GEM_LOOKUPS
COA_AT_SHIP_IND CHAR (1)
COA Required at Shippment Indicator
COA_AT_SHIP_IND_DISP CHAR (3)
COA Required at Shippment Indicator Meaning Resolved using GEM_LOOKUPS
COA_AT_INVOICE_IND CHAR (1)
COA Required at Invoice Indicator
COA_AT_INVOICE_IND_DISP CHAR (3)
COA Required at Invoice Indicator Meaning Resolved using GEM_LOOKUPS
COA_REQ_FROM_SUPL_IND CHAR (1)
COA Required from Supplier Indicator
COA_REQ_FROM_SUPL_IND_DISP CHAR (3)
COA Required from Supplier Indicator Meaning Resolved using GEM_LOOKUPS
BATCH_ID NUMBER

Unique Identifier for Batch
RECIPE_ID NUMBER

Unique Identifier for Recipe
RECIPE_NO CHAR (3)
Recipe Number
RECIPE_VERSION NUMBER

Recipe Version
FORMULA_ID NUMBER

Unique Identifier for Formula
FORMULALINE_ID NUMBER

Unique Identifier for Formula Line
FORMULA_NO CHAR (3)
Formula Number
FORMULA_VERS NUMBER

Formula Version
ROUTING_ID NUMBER

Unique Identifier for Routing
ROUTING_NO CHAR (3)
Routing Number
ROUTING_VERS NUMBER

Routing Version
STEP_ID NUMBER

Unique Identifier for Routing Step
STEP_NO CHAR (3)
Routing Step Number
OPRN_ID NUMBER

Unique Identifier for Operation
OPRN_NO CHAR (3)
Operation Number
OPRN_VERS NUMBER

Operation Version
CHARGE NUMBER

Charge
CUST_ID NUMBER

Unique Identifier for Customer
ORDER_ID NUMBER

Unique Identifier for Order
ORDER_LINE NUMBER

Order Line
ORDER_LINE_ID NUMBER

Unique Identifier for Order Line
SHIP_TO_SITE_ID NUMBER

Unique Identifier for Ship to Site
ORG_ID NUMBER

Unique Identifier for Operating Unit
SUPPLIER_ID NUMBER

Unique Identifier for Supplier
SUPPLIER_SITE_ID NUMBER

Unique Identifier for Supplier Site
PO_HEADER_ID NUMBER

Unique Identifier for Purchase Order Header
PO_LINE_ID NUMBER

Unique Identifier for Purchase Order Line
DELETE_MARK NUMBER

Marked for purge
TEXT_CODE NUMBER

Text Code
CREATION_DATE DATE

ROW WHO Column
CREATED_BY NUMBER

ROW WHO Column
LAST_UPDATED_BY NUMBER

ROW WHO Column
LAST_UPDATE_DATE DATE

ROW WHO Column
LAST_UPDATE_LOGIN NUMBER

ROW WHO Column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SPEC_VR_ID
,      SPEC_ID
,      ORGN_CODE
,      SPEC_TYPE
,      SPEC_TYPE_DISP
,      SPEC_NAME
,      SPEC_VERS
,      ITEM_ID
,      ITEM_NO
,      GRADE
,      SPEC_STATUS
,      SPEC_STATUS_DESC
,      LOT_ID
,      LOT_NO
,      SUBLOT_NO
,      WHSE_CODE
,      LOCATION
,      SPEC_VR_STATUS
,      SPEC_VR_STATUS_DESC
,      START_DATE
,      END_DATE
,      SAMPLING_PLAN_ID
,      SAMPLE_INV_TRANS_IND
,      SAMPLE_INV_TRANS_IND_DISP
,      CONTROL_LOT_ATTRIB_IND
,      CONTROL_LOT_ATTRIB_IND_DISP
,      OUT_OF_SPEC_LOT_STATUS
,      IN_SPEC_LOT_STATUS
,      CONTROL_BATCH_STEP_IND
,      CONTROL_BATCH_STEP_IND_DISP
,      LOT_OPTIONAL_ON_SAMPLE
,      COA_TYPE
,      COA_TYPE_DISP
,      COA_AT_SHIP_IND
,      COA_AT_SHIP_IND_DISP
,      COA_AT_INVOICE_IND
,      COA_AT_INVOICE_IND_DISP
,      COA_REQ_FROM_SUPL_IND
,      COA_REQ_FROM_SUPL_IND_DISP
,      BATCH_ID
,      RECIPE_ID
,      RECIPE_NO
,      RECIPE_VERSION
,      FORMULA_ID
,      FORMULALINE_ID
,      FORMULA_NO
,      FORMULA_VERS
,      ROUTING_ID
,      ROUTING_NO
,      ROUTING_VERS
,      STEP_ID
,      STEP_NO
,      OPRN_ID
,      OPRN_NO
,      OPRN_VERS
,      CHARGE
,      CUST_ID
,      ORDER_ID
,      ORDER_LINE
,      ORDER_LINE_ID
,      SHIP_TO_SITE_ID
,      ORG_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      PO_HEADER_ID
,      PO_LINE_ID
,      DELETE_MARK
,      TEXT_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.PMITS_QC_ALL_SPEC_VRS_V;

Dependencies

[top of page]

APPS.PMITS_QC_ALL_SPEC_VRS_V references the following:

SchemaPUBLIC
SynonymDUAL

APPS.PMITS_QC_ALL_SPEC_VRS_V is not referenced by any database object