Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT BDS.objid, BDS.X_AV_ID_EDS, BDS.X_AV_STATUT_ACT, BDS.X_AV_DATE_EFF,
- (SELECT SUBSTR(BDS1.X_AV_LB_DYNAMIC,22)
- FROM TABLE_CONTR_ITM BDS1
- WHERE BDS1.X_AV_ID_EDS = BDS.X_AV_ID_EDS
- AND BDS1.X_AV_LB_DYNAMIC LIKE 'Maintenance et GTR%') AS ""GTR+Plage de Maintenance"",
- BDS.END_DATE
- FROM TABLE_CONTR_ITM BDS
- WHERE BDS.LINE_NO = 0
- AND EXISTS (
- SELECT *
- FROM TABLE_CONTR_ITM BDS1
- INNER JOIN TABLE_MOD_LEVEL ML
- ON BDS1.contr_itm2mod_level = ML.objid
- INNER JOIN TABLE_PART_NUM BDS_CAT
- ON ML.part_info2part_num = BDS_CAT.objid
- WHERE BDS1.X_AV_ID_EDS = BDS.X_AV_ID_EDS
- AND BDS_CAT.PART_NUMBER IN ('56373','55742','56386','56381')
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement