Bonjour,
j'ai la requete suivante specifique à Oracle :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38 select e.CHARGE_CODE project, e.PRIMARY_LOCATION_CODE proj_goc_off, e.PRELIMINARY_CHARGE_CODE, e.DEPARTMENT_CODE, e.ENGAGEMENT_TYPE, e.SOFT_OPEN_DATE, e.END_DATE, e.CER_APPROVAL_DATE, e.CER_STATUS, e.BILLING_ARRANGEMENT_CODE, e.ORIGINAL_CHARGE_CODE, e.BILLING_SUB_TYPE_CODE, e.CLIENT_INVESTMENT, e.PERFORMANCE_PARTNERSHIP, e.WITHDRAWN_ENGAGEMENT, e.PA_ACTIVITY_CODE, e.ENG_NAME, e.ENG_DESCRIPTION, e.CENTER_SECTOR_CODE, e.ONGOING_CODE, e.MINIMUM_RESERVE_FLAG, e.OPPORTUNITY_COST_INDICATOR, e.HARD_CLOSE_DATE, e.FIRST_ENG_STATUS, e.TASK_NUMBER, p.FMNO ED_FMNO, p.LAST_NAME ED_LAST_NAME, p.FIRST_NAME ED_FIRST_NAME from ENG_ENGAGEMENT e, PSN_PERSON p, ENG_KEY_PLAYER k where CHARGE_CODE is not null and e.PA_ACTIVITY_CODE is not null and e.SRC_ENGAGEMENT_ID=(select min(e2.SRC_ENGAGEMENT_ID) from ENG_ENGAGEMENT e2 where e2.charge_code=e.charge_code) and e.SRC_ENGAGEMENT_ID=k.SRC_ENGAGEMENT_ID (+) and e.SRC_SYSTEM_ID=k.SRC_SYSTEM_ID (+) and k.ED_PERSON_ID=p.PERSON_ID (+)
et je dois la normer
j'ai ecrit le code suivant :
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38 select e.CHARGE_CODE project, e.PRIMARY_LOCATION_CODE proj_goc_off, e.PRELIMINARY_CHARGE_CODE, e.DEPARTMENT_CODE, e.ENGAGEMENT_TYPE, e.SOFT_OPEN_DATE, e.END_DATE, e.CER_APPROVAL_DATE, e.CER_STATUS, e.BILLING_ARRANGEMENT_CODE, e.ORIGINAL_CHARGE_CODE, e.BILLING_SUB_TYPE_CODE, e.CLIENT_INVESTMENT, e.PERFORMANCE_PARTNERSHIP, e.WITHDRAWN_ENGAGEMENT, e.PA_ACTIVITY_CODE, e.ENG_NAME, e.ENG_DESCRIPTION, e.CENTER_SECTOR_CODE, e.ONGOING_CODE, e.MINIMUM_RESERVE_FLAG, e.OPPORTUNITY_COST_INDICATOR, e.HARD_CLOSE_DATE, e.FIRST_ENG_STATUS, e.TASK_NUMBER, p.FMNO ED_FMNO, p.LAST_NAME ED_LAST_NAME, p.FIRST_NAME ED_FIRST_NAME from ENG_ENGAGEMENT e, PSN_PERSON p LEFT OUTER JOIN ENG_KEY_PLAYER k on e.SRC_ENGAGEMENT_ID=k.SRC_ENGAGEMENT_ID LEFT OUTER JOIN ENG_KEY_PLAYER k on e.SRC_SYSTEM_ID=k.SRC_SYSTEM_ID LEFT OUTER JOIN ENG_KEY_PLAYER p on k.ED_PERSON_ID=p.PERSON_ID where CHARGE_CODE is not null and e.PA_ACTIVITY_CODE is not null and e.SRC_ENGAGEMENT_ID=(select min(e2.SRC_ENGAGEMENT_ID) from ENG_ENGAGEMENT e2 where e2.charge_code=e.charge_code)
mais j'obtiens l'erreur suivante :
ERREUR à la ligne 30 :
ORA-00904: "E"."SRC_ENGAGEMENT_ID": invalid identifier
quelqu'un pourrait-il m'expliquer mon erreur?
Partager