[Home] [Help]
View: MTL_GENEALOGY_QA_DATA
View Text
SELECT DISTINCT QPV.PLAN_ID
, QPV.ORGANIZATION_ID
, QPV.NAME
, QPV.DESCRIPTION
, QPV.PLAN_TYPE_DESCRIPTION
, QR.ITEM_ID
, QR.COMP_ITEM_ID
, QR.LOT_NUMBER
, QR.COMP_LOT_NUMBER
, QR.SERIAL_NUMBER
, QR.COMP_SERIAL_NUMBER
, QR.WIP_ENTITY_ID
FROM QA_PLANS_VAL_V QPV
, QA_RESULTS_VAL_V QR
WHERE QPV.PLAN_ID = QR.PLAN_ID
Columns
Name |
PLAN_ID |
ORGANIZATION_ID |
NAME |
DESCRIPTION |
PLAN_TYPE_DESCRIPTION |
ITEM_ID |
COMP_ITEM_ID |
LOT_NUMBER |
COMP_LOT_NUMBER |
SERIAL_NUMBER |
COMP_SERIAL_NUMBER |
WIP_ENTITY_ID |