[Home] [Help]
View: EAM_CFR_QA_PLANS_V
Product: | EAM - Enterprise Asset Management |
Description: | This view displays information on QA Plans for work orders.This view is used for ERES at the time of Work Order Completion in the XGM |
Implementation/DBA Data: |
APPS.EAM_CFR_QA_PLANS_V
|
View Text
SELECT DISTINCT QR.PLAN_ID
, QP.NAME
, QR.WORK_ORDER_ID
, QR.TRANSACTION_NUMBER
FROM QA_RESULTS QR
, QA_PLANS QP
WHERE QR.PLAN_ID = QP.PLAN_ID
AND QR.STATUS = 2
Columns
Name |
PLAN_ID |
NAME |
WIP_ENTITY_ID |
TRANSACTION_NUMBER |