[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 |
APPS.MTL_GENEALOGY_QA_DATA