971: SELECT SUBSTR(ARP_ADDR_LABEL_PKG.FORMAT_ADDRESS(NULL,HL.ADDRESS1,HL.ADDRESS2,HL.ADDRESS3,
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
998: HL.ADDRESS4,HL.CITY,HL.COUNTY,HL.STATE,HL.PROVINCE,HL.POSTAL_CODE,NULL,HL.COUNTRY,
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
1083:
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
1114: SELECT psu.party_site_use_id
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