APPS.OKL_LLA_UTIL_PVT dependencies on OKC_K_ITEMS

Line 977: OKC_K_ITEMS CIM

973: HL.ADDRESS4,HL.CITY,HL.COUNTY,HL.STATE,HL.PROVINCE,HL.POSTAL_CODE,NULL,HL.COUNTRY,
974: NULL, NULL,NULL,NULL,NULL,NULL,NULL,'N','N',80,1,1),1,80) DESCRIPTION
975: FROM HZ_LOCATIONS HL,
976: CSI_ITEM_INSTANCES CSI,
977: OKC_K_ITEMS CIM
978: WHERE CIM.CLE_ID = (SELECT A.ID
979: FROM OKC_K_LINES_V A,
980: OKC_LINE_STYLES_B B
981: WHERE CLE_ID = (SELECT A.ID

Line 1004: OKC_K_ITEMS CIM

1000: NULL, NULL,NULL,NULL,NULL,NULL,NULL,'N','N',80,1,1),1,80) DESCRIPTION
1001: FROM HZ_LOCATIONS HL,
1002: HZ_PARTY_SITES HPS,
1003: CSI_ITEM_INSTANCES CSI,
1004: OKC_K_ITEMS CIM
1005: WHERE CIM.CLE_ID = (SELECT A.ID
1006: FROM OKC_K_LINES_V A,
1007: OKC_LINE_STYLES_B B
1008: WHERE CLE_ID = (SELECT A.ID

Line 1089: OKC_K_ITEMS CIM,

1085: CURSOR l_get_booked_Astloc_csr IS
1086: SELECT psu.party_site_use_id
1087: FROM HZ_LOCATIONS HL,
1088: CSI_ITEM_INSTANCES CSI,
1089: OKC_K_ITEMS CIM,
1090: hz_party_site_uses psu,
1091: hz_party_sites hps
1092: WHERE CIM.CLE_ID in (SELECT A.ID
1093: FROM OKC_K_LINES_V A,

Line 1120: OKC_K_ITEMS CIM

1116: FROM HZ_LOCATIONS HL,
1117: HZ_PARTY_SITES HPS,
1118: HZ_PARTY_SITE_USES PSU,
1119: CSI_ITEM_INSTANCES CSI,
1120: OKC_K_ITEMS CIM
1121: WHERE CIM.CLE_ID in (SELECT A.ID
1122: FROM OKC_K_LINES_V A,
1123: OKC_LINE_STYLES_B B
1124: WHERE CLE_ID in (SELECT A.ID

Line 1206: , OKC_K_ITEMS CIM_FA

1202: FROM OKC_K_LINES_V CLE_FIN
1203: , OKC_LINE_STYLES_B LSE_FIN
1204: , OKC_K_LINES_B CLE_FA
1205: , OKC_LINE_STYLES_B LSE_FA
1206: , OKC_K_ITEMS CIM_FA
1207: , FA_ADDITIONS_B FAV
1208: WHERE CLE_FIN.CLE_ID IS NULL
1209: AND CLE_FIN.id = p_kle_id
1210: AND CLE_FIN.DNZ_CHR_ID = p_khr_id