Siebel Log - Part 23

An example of a business component visualization: this log line 2034 BC Position

Relationship diagram (D2)

Tables

Alias	Schema.Table
T1	SIEBEL.S_ORG_EXT
T10	SIEBEL.S_USER
T11	SIEBEL.S_PARTY
T12	SIEBEL.S_EMP_PER
T13	SIEBEL.S_ADDR_PER
T14	SIEBEL.S_CONTACT
T15	SIEBEL.S_POSTN
T2	SIEBEL.S_CONTACT
T3	SIEBEL.S_POSTN
T4	SIEBEL.S_PARTY_PER
T5	SIEBEL.CX_APP_COM
T6	SIEBEL.S_USER
T7	SIEBEL.S_PARTY_PER
T8	SIEBEL.S_PARTY
T9	SIEBEL.S_CON_ADDR

Selectable columns

#	Column	Source
1	T11.ROW_ID	T11
2	T1.NAME	T1
3	T15.OU_ID	T15
4	T14.JOB_TITLE	T14
5	T15.PR_TERR_ID	T15
6	T14.FST_NAME	T14
7	T1.DIVN_TYPE_CD	T1
8	T15.PR_POSTN_ADDR_ID	T15
9	T14.EMayL_ADDR	T14
10	T14.FAX_PH_NUM	T14
11	T15.BU_ID	T15
12	T3.PR_EMP_ID	T3
13	T15.BL_PROD_ID	T15
14	T15.X_MEMBRU_CPAC	T15
15	T15.X_NR_CNT_ASGN	T15
16	T15.X_PR_DEPT_ID	T15
17	T3.OU_ID	T3
18	T1.PAR_DIVN_ID	T1
19	T15.ROW_ID	T15
20	T1.BASE_CURCY_CD	T1
21	T14.X_EMPLOYEE_JK_EMayL	T14
22	T15.CMPNS_CURCY_CD	T15
23	T15.CP_PLAN_LVL_NUM	T15
24	T12.EMP_STAT_CD	T12
25	T15.PGROUP_ID	T15
26	T10.LOGIN	T10
27	T14.WORK_PH_NUM	T14
28	T15.PR_EMP_ID	T15
29	T14.LAST_NAME	T14
30	T15.NAME	T15
31	T2.FST_NAME	T2
32	T2.LAST_NAME	T2
33	T6.LOGIN	T6
34	T13.ADDR	T13
35	T5.COMMITTEE_TYPE	T5
36	T5.ROW_ID	T5
37	T15.PAR_ROW_ID	T15
38	T4.ROW_ID	T4
39	T8.ROW_ID	T8
40	T9.ROW_ID	T9
41	T13.ROW_ID	T13
42	T7.ROW_ID	T7
43	T7.PERSON_ID	T7
44	T7.PARTY_ID	T7

Conditions JOIN

• T7.PARTY_ID = T11.ROW_ID
• T15.X_MEMBRU_CPAC = T5.ROW_ID (+) (+)
• T15.PR_POSTN_ADDR_ID = T13.ROW_ID (+) (+)
• T15.OU_ID = T9.ACCNT_ID (+) (+)
• T15.PR_POSTN_ADDR_ID = T9.ADDR_PER_ID (+) (+)
• T15.PR_EMP_ID = T6.PAR_ROW_ID (+) (+)
• T15.PR_EMP_ID = T2.PAR_ROW_ID (+) (+)
• T15.PR_EMP_ID = T8.ROW_ID (+) (+)
• T15.ROW_ID = T4.PARTY_ID (+) (+)
• T15.PR_EMP_ID = T4.PERSON_ID (+) (+)
• T11.ROW_ID = T15.PAR_ROW_ID
• T15.OU_ID = T1.PAR_ROW_ID
• T15.PR_EMP_ID = T14.PAR_ROW_ID (+) (+)
• T15.PR_EMP_ID = T12.PAR_ROW_ID (+) (+)
• T15.PR_EMP_ID = T10.PAR_ROW_ID (+) (+)
• T11.PAR_PARTY_ID = T3.PAR_ROW_ID (+) (+)

Filters (WHERE)

• T7.PERSON_ID = '1-3KURRQI'

ORDER BY

T15.NAME

SQL (pretty)

SELECT
  T11.ROW_ID,
  T1.NAME,
  T15.OU_ID,
  T14.JOB_TITLE,
  T15.PR_TERR_ID,
  T14.FST_NAME,
  T1.DIVN_TYPE_CD,
  T15.PR_POSTN_ADDR_ID,
  T14.EMayL_ADDR,
  T14.FAX_PH_NUM,
  T15.BU_ID,
  T3.PR_EMP_ID,
  T15.BL_PROD_ID,
  T15.X_MEMBRU_CPAC,
  T15.X_NR_CNT_ASGN,
  T15.X_PR_DEPT_ID,
  T3.OU_ID,
  T1.PAR_DIVN_ID,
  T15.ROW_ID,
  T1.BASE_CURCY_CD,
  T14.X_EMPLOYEE_JK_EMayL,
  T15.CMPNS_CURCY_CD,
  T15.CP_PLAN_LVL_NUM,
  T12.EMP_STAT_CD,
  T15.PGROUP_ID,
  T10.LOGIN,
  T14.WORK_PH_NUM,
  T15.PR_EMP_ID,
  T14.LAST_NAME,
  T15.NAME,
  T2.FST_NAME,
  T2.LAST_NAME,
  T6.LOGIN,
  T13.ADDR,
  T5.COMMITTEE_TYPE,
  T5.ROW_ID,
  T15.PAR_ROW_ID,
  T4.ROW_ID,
  T8.ROW_ID,
  T9.ROW_ID,
  T13.ROW_ID,
  T7.ROW_ID,
  T7.PERSON_ID,
  T7.PARTY_ID
FROM SIEBEL.S_ORG_EXT T1, SIEBEL.S_CONTACT T2, SIEBEL.S_POSTN T3, SIEBEL.S_PARTY_PER T4, SIEBEL.CX_APP_COM T5, SIEBEL.S_USER T6, SIEBEL.S_PARTY_PER T7, SIEBEL.S_PARTY T8, SIEBEL.S_CON_ADDR T9, SIEBEL.S_USER T10, SIEBEL.S_PARTY T11, SIEBEL.S_EMP_PER T12, SIEBEL.S_ADDR_PER T13, SIEBEL.S_CONTACT T14, SIEBEL.S_POSTN T15
WHERE
  T15.PR_EMP_ID = T10.PAR_ROW_ID (+)
  AND T11.PAR_PARTY_ID = T3.PAR_ROW_ID (+)
  AND T15.PR_EMP_ID = T12.PAR_ROW_ID (+)
  AND T15.PR_EMP_ID = T14.PAR_ROW_ID (+)
  AND T15.OU_ID = T1.PAR_ROW_ID
  AND T11.ROW_ID = T15.PAR_ROW_ID
  AND T15.PR_EMP_ID = T4.PERSON_ID (+)
  AND T15.ROW_ID = T4.PARTY_ID (+)
  AND T15.PR_EMP_ID = T8.ROW_ID (+)
  AND T15.PR_EMP_ID = T2.PAR_ROW_ID (+)
  AND T15.PR_EMP_ID = T6.PAR_ROW_ID (+)
  AND T15.PR_POSTN_ADDR_ID = T9.ADDR_PER_ID (+)
  AND T15.OU_ID = T9.ACCNT_ID (+)
  AND T15.PR_POSTN_ADDR_ID = T13.ROW_ID (+)
  AND T15.X_MEMBRU_CPAC = T5.ROW_ID (+)
  AND T7.PARTY_ID = T11.ROW_ID
  AND (
    T7.PERSON_ID = '1-3KURRQI'
  )
ORDER BY
  T15.NAME

Source file

part1_details_2034.md

Note

Oracle’s outer-join operator (+) is restored from the source text if sqlglot removed it during parsing.