APPS.OKL_LLA_UTIL_PVT dependencies on OKC_K_ITEMS

Line 976: OKC_K_ITEMS CIM

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

Line 1003: OKC_K_ITEMS CIM

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

Line 1088: OKC_K_ITEMS CIM,

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

Line 1119: OKC_K_ITEMS CIM

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

Line 1205: , OKC_K_ITEMS CIM_FA

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