Project

General

Profile

Download (2.64 KB)

Feature #3646 » CBKT_GetOrgInOrgWide_202507171110.sql

Tri Rizqiaty, 07/17/2025 02:14 PM

 
1 
??ALTER FUNCTION [dbo].[CBKT_GetOrgInOrgWide]
2
3 
	(@org_id varchar(20),
4
5 
	@ref_date varchar(20))
6
7 
	--@landscape varchar(3))
8
9 
RETURNS @result TABLE (
10
11 
	org_id varchar(20),
12
13 
	org_name varchar(250),
14
15 
	org_level varchar(20),
16
17 
	parent_org_id varchar(20),
18
19 
	parent_org_name varchar(250),
20
21 
	parent_org_level varchar(20),
22
23 
	org_id_00 varchar(20),
24
25 
	org_name_00 varchar(250),
26
27 
	org_id_01 varchar(20),
28
29 
	org_name_01 varchar(250),
30
31 
	org_id_02 varchar(20),
32
33 
	org_name_02 varchar(250),
34
35 
	org_id_03 varchar(20),
36
37 
	org_name_03 varchar(250),
38
39 
	org_id_04 varchar(20),
40
41 
	org_name_04 varchar(250),
42
43 
	org_id_05 varchar(20),
44
45 
	org_name_05 varchar(250),
46
47 
	org_id_06 varchar(20),
48
49 
	org_name_06 varchar(250),
50
51 
	org_id_07 varchar(20),
52
53 
	org_name_07 varchar(250),
54
55 
	org_id_08 varchar(20),
56
57 
	org_name_08 varchar(250),
58
59 
	org_id_09 varchar(20),
60
61 
	org_name_09 varchar(250),
62
63 
	org_id_10 varchar(20),
64
65 
	org_name_10 varchar(250),
66
67 
	org_id_11 varchar(20),
68
69 
	org_name_11 varchar(250),
70
71 
	org_id_12 varchar(20),
72
73 
	org_name_12 varchar(250)
74
75 
	)
76
77 
/*
78
79 
SELECT * FROM dbo.GetOrgInOrg('00009004','20110101','','100', 1, 1)
80
81 
*/
82
83 
BEGIN
84
85
86
87 
	INSERT INTO @result
88
89 
	SELECT * FROM dbo.CBKT_GetOrgInOrgWideDetail(@org_id,@ref_date,1,'','',
90
91 
	'','',
92
93 
	'','',
94
95 
	'','',
96
97 
	'','',
98
99 
	'','',
100
101 
	'','',
102
103 
	'','',
104
105 
	'','',
106
107 
	'',''
108
109 
	,'',''
110
111 
	,'',''
112
113 
	,'',''
114
115 
	,'',''
116
117 
	)
118
119
120
121 
	RETURN
122
123 
END
124
125
126
127
128
129
130
131
132
133
(17-17/23)