APPS.OKC_CNL_PVT dependencies on OKC_CONDITION_LINES_TLH

Line 109: DELETE FROM OKC_CONDITION_LINES_TLH T

105: FROM OKC_CONDITION_LINES_TL T
106: WHERE T.ID = B.ID
107: AND T.LANGUAGE = L.LANGUAGE_CODE
108: );
109: DELETE FROM OKC_CONDITION_LINES_TLH T
110: WHERE NOT EXISTS (
111: SELECT NULL
112: FROM OKC_CONDITION_LINES_BH B
113: WHERE B.ID = T.ID

Line 118: UPDATE OKC_CONDITION_LINES_TLH T SET (

114: AND B.MAJOR_VERSION = T.MAJOR_VERSION
115: );
116:
117:
118: UPDATE OKC_CONDITION_LINES_TLH T SET (
119: DESCRIPTION) = (SELECT
120: B.DESCRIPTION
121: FROM OKC_CONDITION_LINES_TLH B
122: WHERE B.ID = T.ID

Line 121: FROM OKC_CONDITION_LINES_TLH B

117:
118: UPDATE OKC_CONDITION_LINES_TLH T SET (
119: DESCRIPTION) = (SELECT
120: B.DESCRIPTION
121: FROM OKC_CONDITION_LINES_TLH B
122: WHERE B.ID = T.ID
123: AND B.MAJOR_VERSION = T.MAJOR_VERSION
124: AND B.LANGUAGE = T.SOURCE_LANG)
125: WHERE (

Line 133: FROM OKC_CONDITION_LINES_TLH SUBB, OKC_CONDITION_LINES_TLH SUBT

129: IN (SELECT
130: SUBT.ID,
131: SUBT.MAJOR_VERSION,
132: SUBT.LANGUAGE
133: FROM OKC_CONDITION_LINES_TLH SUBB, OKC_CONDITION_LINES_TLH SUBT
134:
135: WHERE SUBB.ID = SUBT.ID
136: AND SUBB.MAJOR_VERSION = SUBT.MAJOR_VERSION
137: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 144: INSERT INTO OKC_CONDITION_LINES_TLH (

140: IS NOT NULL)
141: OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION
142: IS NULL)
143: ));
144: INSERT INTO OKC_CONDITION_LINES_TLH (
145: ID,
146: LANGUAGE,
147: MAJOR_VERSION,
148: SOURCE_LANG,

Line 168: FROM OKC_CONDITION_LINES_TLH B, FND_LANGUAGES L

164: B.CREATION_DATE,
165: B.LAST_UPDATED_BY,
166: B.LAST_UPDATE_DATE,
167: B.LAST_UPDATE_LOGIN
168: FROM OKC_CONDITION_LINES_TLH B, FND_LANGUAGES L
169: WHERE L.INSTALLED_FLAG IN ('I', 'B')
170: AND B.LANGUAGE = USERENV('LANG')
171: AND NOT EXISTS(
172: SELECT NULL

Line 173: FROM OKC_CONDITION_LINES_TLH T

169: WHERE L.INSTALLED_FLAG IN ('I', 'B')
170: AND B.LANGUAGE = USERENV('LANG')
171: AND NOT EXISTS(
172: SELECT NULL
173: FROM OKC_CONDITION_LINES_TLH T
174: WHERE T.ID = B.ID
175: AND B.MAJOR_VERSION = T.MAJOR_VERSION
176: AND T.LANGUAGE = L.LANGUAGE_CODE
177: );

Line 5549: INSERT INTO okc_condition_lines_tlh

5545: ---------------------------------------
5546: -- Versioning TL Table
5547: ---------------------------------------
5548:
5549: INSERT INTO okc_condition_lines_tlh
5550: (
5551: major_version,
5552: id,
5553: language,

Line 5632: FROM okc_condition_lines_tlh

5628: creation_date,
5629: last_updated_by,
5630: last_update_date,
5631: last_update_login
5632: FROM okc_condition_lines_tlh
5633: WHERE id in (SELECT id
5634: FROM okc_condition_lines_bh
5635: WHERE dnz_chr_id = p_chr_id)
5636: AND major_version = p_major_version;