APPS.OKC_CLE_PVT dependencies on OKC_K_LINES_TLH

Line 2895: DELETE FROM OKC_K_LINES_TLH T

2891: AND t.id IS NULL;
2892:
2893: /* Commenting delete and update for bug 3723874 */
2894: /*
2895: DELETE FROM OKC_K_LINES_TLH T
2896: WHERE NOT EXISTS (
2897: SELECT NULL
2898: FROM OKC_K_LINES_BH B
2899: WHERE B.ID = T.ID

Line 2903: UPDATE OKC_K_LINES_TLH T SET (

2899: WHERE B.ID = T.ID
2900: AND T.MAJOR_VERSION = B.MAJOR_VERSION
2901: );
2902:
2903: UPDATE OKC_K_LINES_TLH T SET (
2904: NAME,
2905: COMMENTS,
2906: ITEM_DESCRIPTION,
2907: OKE_BOE_DESCRIPTION,

Line 2916: FROM OKC_K_LINES_TLH B

2912: B.ITEM_DESCRIPTION,
2913: B.OKE_BOE_DESCRIPTION,
2914: B.COGNOMEN,
2915: B.BLOCK23TEXT
2916: FROM OKC_K_LINES_TLH B
2917: WHERE B.ID = T.ID
2918: AND B.MAJOR_VERSION = T.MAJOR_VERSION
2919: AND B.LANGUAGE = T.SOURCE_LANG)
2920: WHERE (

Line 2928: FROM OKC_K_LINES_TLH SUBB, OKC_K_LINES_TLH SUBT

2924: IN (SELECT
2925: SUBT.ID,
2926: SUBT.MAJOR_VERSION,
2927: SUBT.LANGUAGE
2928: FROM OKC_K_LINES_TLH SUBB, OKC_K_LINES_TLH SUBT
2929: WHERE SUBB.ID = SUBT.ID
2930: AND SUBB.MAJOR_VERSION = SUBT.MAJOR_VERSION
2931: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
2932: AND (SUBB.NAME <> SUBT.NAME

Line 2953: INSERT /*+ append parallel(tt) */ INTO OKC_K_LINES_TLH tt (

2949: OR (SUBB.BLOCK23TEXT IS NOT NULL AND SUBT.BLOCK23TEXT IS NULL)
2950: ));
2951: */
2952: /* Modifying Insert as per performance guidelines given in bug 3723874 */
2953: INSERT /*+ append parallel(tt) */ INTO OKC_K_LINES_TLH tt (
2954: ID,
2955: LANGUAGE,
2956: MAJOR_VERSION,
2957: SOURCE_LANG,

Line 2989: FROM OKC_K_LINES_TLH B, FND_LANGUAGES L

2985: B.CREATION_DATE,
2986: B.LAST_UPDATED_BY,
2987: B.LAST_UPDATE_DATE,
2988: B.LAST_UPDATE_LOGIN
2989: FROM OKC_K_LINES_TLH B, FND_LANGUAGES L
2990: WHERE L.INSTALLED_FLAG IN ('I', 'B')
2991: AND B.LANGUAGE = USERENV('LANG')
2992: ) v , OKC_K_LINES_TLH T
2993: WHERE T.ID(+) = v.ID

Line 2992: ) v , OKC_K_LINES_TLH T

2988: B.LAST_UPDATE_LOGIN
2989: FROM OKC_K_LINES_TLH B, FND_LANGUAGES L
2990: WHERE L.INSTALLED_FLAG IN ('I', 'B')
2991: AND B.LANGUAGE = USERENV('LANG')
2992: ) v , OKC_K_LINES_TLH T
2993: WHERE T.ID(+) = v.ID
2994: AND T.LANGUAGE(+) = v.LANGUAGE_CODE
2995: AND T.MAJOR_VERSION(+) = v.MAJOR_VERSION
2996: AND t.id IS NULL;

Line 9443: INSERT INTO okc_k_lines_tlh

9439: ----------------------------------
9440: -- Version TL Table
9441: ----------------------------------
9442:
9443: INSERT INTO okc_k_lines_tlh
9444: (
9445: major_version,
9446: id,
9447: language,

Line 9566: FROM okc_k_lines_tlh

9562: creation_date,
9563: last_updated_by,
9564: last_update_date,
9565: last_update_login
9566: FROM okc_k_lines_tlh
9567: WHERE id in (SELECT id
9568: FROM okc_k_lines_bh
9569: WHERE dnz_chr_id = p_chr_id)
9570: AND major_version = p_major_version;