质检任务单据表关系

 

单据头 Z_QM_TASKLLIST

SELECT x.*,x.ROWID FROM WIPDBA.Z_QM_TASKLLIST x

WHERE (HANDLE = 'QmTaskLListBO:1130,SJ,11300303S221015033') AND (SHOP_ORDER_BO LIKE '%222800450710%')

单据行 Z_QM_TASKLLIST_PA

SELECT x.*,x.ROWID FROM WIPDBA.Z_QM_TASKLLIST_PA x

WHERE (Z_QM_TASKLLIST_BO = 'QmTaskLListBO:1130,SJ,11300303S221015033') AND (PARAMETRIC_BO = 'PA:1130,1665821360508000888211100')

ORDER BY x.BJSJ DESC

 

Z_QM_TASKLLIST 和 PARAMETRIC 一对一

 

SELECT x.*,x.ROWID FROM WIPDBA.PARAMETRIC x

WHERE HANDLE = 'PA:1130,1665821360508000888211100'

 

PARAMETRIC 的实际测试结构保存在 PARAMETRIC_MEASURE 一对多

SELECT x.*,x.ROWID FROM WIPDBA.PARAMETRIC_MEASURE x

WHERE PARAMETRIC_BO = 'PA:1130,1665821360508000888211100'