eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_QA_DATA_INTEGRITY dependencies on OKC_K_LINES_B

Line 23: FROM OKC_K_LINES_B

19: RETURN VARCHAR2 IS
20:
21: CURSOR l_get_top_line_number_csr (p_line_id NUMBER) IS
22: SELECT line_number, cle_id
23: FROM OKC_K_LINES_B
24: WHERE id = p_line_id;
25:
26:
27: l_line_num VARCHAR2(150);

Line 145: FROM OKC_K_LINES_B

141: clev.id = p_cle_id;
142:
143: CURSOR l_get_top_line_number_csr (p_line_id NUMBER) IS
144: SELECT line_number
145: FROM OKC_K_LINES_B
146: WHERE id = p_line_id;
147:
148: CURSOR l_line_name_csr IS
149: SELECT RTRIM(RTRIM(line_number) || ', ' || RTRIM(lsev.name) || ' ' ||

Line 517: FROM okc_k_lines_b WHERE chr_id = p_chr_id

513:
514: CURSOR get_line_info(p_chr_id NUMBER) IS
515: /**
516: SELECT line_number, price_list_id, sts_code
517: FROM okc_k_lines_b WHERE chr_id = p_chr_id
518: AND lse_id IN (1, 12, 46, 19)
519: AND date_cancelled IS NULL ; --Changes [llc]
520: **/
521: --bug 5442886

Line 523: FROM okc_k_lines_b,

519: AND date_cancelled IS NULL ; --Changes [llc]
520: **/
521: --bug 5442886
522: SELECT line_number, price_list_id
523: FROM okc_k_lines_b,
524: okc_statuses_b
525: WHERE chr_id = p_chr_id
526: AND lse_id IN (1,12,46,19)
527: AND ste_code = 'ENTERED'

Line 531: TYPE chr150_tbl_type IS TABLE OF okc_k_lines_b.line_number%TYPE INDEX BY BINARY_INTEGER;

527: AND ste_code = 'ENTERED'
528: AND code = sts_code
529: AND date_cancelled IS NULL;
530:
531: TYPE chr150_tbl_type IS TABLE OF okc_k_lines_b.line_number%TYPE INDEX BY BINARY_INTEGER;
532: TYPE num_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
533:
534: l_line_number_tbl chr150_tbl_type;
535: l_price_list_id_tbl num_tbl_type;

Line 1063: OKC_K_LINES_B cle,

1059: , chdr.contract_number_modifier
1060: FROM okc_k_headers_all_b chdr,
1061: OKC_K_ITEMS cim,
1062: OKC_LINE_STYLES_V lse,
1063: OKC_K_LINES_B cle,
1064: OKC_STATUSES_B sts
1065: WHERE chdr.id = cle.dnz_chr_id
1066: AND object1_id1 = p_object1_id1
1067: AND object1_id2 = p_object1_id2

Line 1322: okc_k_lines_b trgtl,

1318: srcsl.id srcsl_id
1319: FROM okc_k_headers_all_b trgh,
1320: okc_k_lines_v trgsl,
1321: okc_k_items trgi,
1322: okc_k_lines_b trgtl,
1323: okc_line_styles_v trgst,
1324: okc_k_lines_v srcsl,
1325: okc_k_items srci,
1326: okc_k_lines_b srctl,

Line 1326: okc_k_lines_b srctl,

1322: okc_k_lines_b trgtl,
1323: okc_line_styles_v trgst,
1324: okc_k_lines_v srcsl,
1325: okc_k_items srci,
1326: okc_k_lines_b srctl,
1327: okc_line_styles_v srcst,
1328: okc_statuses_b sts
1329: WHERE srcsl.dnz_chr_id = cp_chr_id
1330: AND srcsl.lse_id IN (7, 8, 9, 10, 11, 35, 13, 18, 25)

Line 1654: OKC_K_LINES_B cle

1650:
1651: CURSOR l_cva_csr (p_cle_id NUMBER) IS
1652: SELECT COUNT( * )
1653: FROM OKC_LINE_STYLES_B lse,
1654: OKC_K_LINES_B cle
1655: WHERE lse.lty_code = 'COVERAGE'
1656: AND lse.id = cle.lse_id
1657: AND cle.cle_id = p_cle_id
1658: GROUP BY cle.cle_id;

Line 1700: , okc_k_lines_b lines

1696: CURSOR l_Contact_csr(p_cle_id NUMBER) IS
1697: SELECT Contact.object1_id1
1698: FROM Okc_contacts Contact
1699: , Okc_k_party_roles_b Party
1700: , okc_k_lines_b lines
1701: WHERE Contact.cpl_id = Party.id
1702: AND party.cle_id = p_cle_id
1703: AND party.jtot_object1_code = 'OKX_PARTY'
1704: AND Contact.cro_code = 'CUST_BILLING'

Line 1711: FROM OKC_K_LINES_B

1707:
1708: -- object1_id1 in BTO
1709: CURSOR l_billto_csr(p_id NUMBER) IS
1710: SELECT BILL_TO_SITE_USE_ID
1711: FROM OKC_K_LINES_B
1712: -- Bug 4558172 --
1713: -- where cle_id = p_id;
1714: WHERE id = p_id;
1715: -- Bug 4558172 --

Line 2112: OKC_K_LINES_B cle

2108: CURSOR l_cle_csr IS
2109: /**
2110: SELECT cle.id, COUNT( * )
2111: FROM OKC_K_ITEMS cim,
2112: OKC_K_LINES_B cle
2113: WHERE cim.cle_id = cle.id
2114: AND cle.dnz_chr_id = p_chr_id
2115: AND cle.date_cancelled IS NULL --Changes [llc]
2116: GROUP BY cle.id

Line 2178: FROM OKC_K_LINES_B

2174:
2175: /***
2176: CURSOR l_get_top_line_csr IS
2177: SELECT id
2178: FROM OKC_K_LINES_B
2179: WHERE dnz_chr_id = p_chr_id
2180: AND lse_id IN (1, 19)
2181: AND date_cancelled IS NULL ; --Changes [llc]
2182:

Line 2185: FROM OKC_K_LINES_B

2181: AND date_cancelled IS NULL ; --Changes [llc]
2182:
2183: CURSOR l_get_sub_line_csr (p_cle_id NUMBER) IS
2184: SELECT id, price_unit
2185: FROM OKC_K_LINES_B
2186: WHERE dnz_chr_id = p_chr_id
2187: AND cle_id = p_cle_id
2188: AND lse_id IN (7, 8, 9, 10, 11, 18, 25, 35)
2189: AND date_cancelled IS NULL --Changes [llc]

Line 2204: FROM okc_k_lines_b rla,

2200: CURSOR l_get_line_details_csr IS
2201: SELECT /*+ ordered use_nl(rlb,ri) */
2202: rlb.id sub_line_id, rlb.price_unit,
2203: ri.uom_code
2204: FROM okc_k_lines_b rla,
2205: okc_k_lines_b rlb,
2206: okc_k_items_v ri
2207: WHERE rla.dnz_chr_id = p_chr_id
2208: AND rla.lse_id IN (1,19)

Line 2205: okc_k_lines_b rlb,

2201: SELECT /*+ ordered use_nl(rlb,ri) */
2202: rlb.id sub_line_id, rlb.price_unit,
2203: ri.uom_code
2204: FROM okc_k_lines_b rla,
2205: okc_k_lines_b rlb,
2206: okc_k_items_v ri
2207: WHERE rla.dnz_chr_id = p_chr_id
2208: AND rla.lse_id IN (1,19)
2209: AND rla.date_cancelled IS NULL

Line 2272: FROM okc_k_lines_b

2268: /*** Get customer id for all the above service lines ***/
2269: -- object1_id1 in CAN rule
2270: CURSOR l_csr_get_customer_id IS
2271: SELECT CUST_ACCT_ID -- object1_id1
2272: FROM okc_k_lines_b
2273: WHERE id = l_service_id;
2274:
2275:
2276: /*** Get service item id for all the service lines from OKC_K_ITEMS_V ***/

Line 2324: FROM okc_k_lines_b

2320:
2321: l_date_cancelled := NULL;
2322: SELECT date_cancelled
2323: INTO l_date_cancelled
2324: FROM okc_k_lines_b
2325: WHERE id = l_cle_rec.cle_id;
2326:
2327: IF l_date_cancelled IS NULL THEN
2328: OKC_API.set_message(

Line 2979: OKC_K_LINES_B CLEB,

2975: exempt_certificate_number,
2976: exempt_reason_code
2977:
2978: FROM
2979: OKC_K_LINES_B CLEB,
2980: OKS_K_LINES_B KLN
2981: WHERE
2982: CLEB.dnz_chr_id = p_chr_id AND
2983: CLEB.ID = KLN.CLE_ID AND

Line 3934: FROM okc_k_lines_b rl,

3930: -- BTO rule. Replaced okx_cust_site_uses_v with HZ_CUST_SITE_USES_ALL
3931: CURSOR check_address (line_id NUMBER, l_use_code VARCHAR2)
3932: IS
3933: SELECT CS.SITE_USE_ID, CS.STATUS, CS.CUST_ACCT_SITE_ID
3934: FROM okc_k_lines_b rl,
3935: HZ_CUST_SITE_USES_ALL CS
3936: WHERE rl.dnz_chr_id = p_chr_id
3937: AND rl.id = line_id
3938: AND CS.SITE_USE_ID = decode(l_use_code, 'BILL_TO', rl.BILL_TO_SITE_USE_ID, rl.SHIP_TO_SITE_USE_ID)

Line 3952: SELECT id, line_number FROM okc_k_lines_b

3948:
3949: /******
3950: -- checks bill to address for top lines.
3951: CURSOR line_cur IS
3952: SELECT id, line_number FROM okc_k_lines_b
3953: WHERE dnz_chr_id = p_chr_id
3954: AND chr_id = p_chr_id
3955: AND cle_id IS NULL
3956: AND lse_id IN (1, 12, 14, 19, 46)

Line 3971: FROM okc_k_lines_b rl,

3967: cs.site_use_id, cs.status site_use_status,
3968: cs.cust_acct_site_id,
3969: ca.status site_status,
3970: 'BILL_TO' use_code
3971: FROM okc_k_lines_b rl,
3972: hz_cust_site_uses_all cs,
3973: hz_cust_acct_sites_all ca
3974: WHERE rl.dnz_chr_id = p_chr_id
3975: AND rl.chr_id = p_chr_id

Line 3991: FROM okc_k_lines_b rl,

3987: cs.site_use_id, cs.status site_use_status,
3988: cs.cust_acct_site_id,
3989: ca.status site_status,
3990: 'SHIP_TO' use_code
3991: FROM okc_k_lines_b rl,
3992: hz_cust_site_uses_all cs,
3993: hz_cust_acct_sites_all ca
3994: WHERE rl.dnz_chr_id = p_chr_id
3995: AND rl.chr_id = p_chr_id

Line 4006: TYPE chr150_tbl_type IS TABLE OF okc_k_lines_b.line_number%TYPE INDEX BY BINARY_INTEGER;

4002: AND cs.site_use_code (+)= 'SHIP_TO' --l_use_code -- 'bill_to' or 'ship_to'
4003: --
4004: AND ca.cust_acct_site_id (+)= cs.cust_acct_site_id;
4005:
4006: TYPE chr150_tbl_type IS TABLE OF okc_k_lines_b.line_number%TYPE INDEX BY BINARY_INTEGER;
4007: TYPE chr7_tbl_type IS TABLE OF VARCHAR2(7) INDEX BY BINARY_INTEGER;
4008: TYPE chr1a_tbl_type IS TABLE OF hz_cust_site_uses_all.status%TYPE INDEX BY BINARY_INTEGER;
4009: TYPE chr1b_tbl_type IS TABLE OF hz_cust_acct_sites_all.status%TYPE INDEX BY BINARY_INTEGER;
4010: TYPE num_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 4354: okc_k_lines_b cle,

4350: SELECT cle.id, cle.lse_id, sts.ste_code sts_code,
4351: cle.start_date, cle.end_date, cle.date_terminated,
4352: cim.jtot_object1_code, cim.object1_id1, cim.object1_id2
4353: FROM okc_k_items cim,
4354: okc_k_lines_b cle,
4355: okc_statuses_b sts
4356: WHERE cle.dnz_chr_id = p_chr_id
4357: AND cle.cle_id IS NULL
4358: AND sts.code = cle.sts_code

Line 4399: OKC_K_LINES_B cle,

4395: cle.start_date, cle.end_date, cle.date_terminated,
4396: cim.jtot_object1_code, cim.object1_id1,
4397: cim.object1_id2
4398: FROM OKC_K_ITEMS cim,
4399: OKC_K_LINES_B cle,
4400: OKC_STATUSES_B sts
4401: WHERE cim.cle_id = cle.id
4402: AND cle.cle_id = p_cle_id
4403: AND sts.code = cle.sts_code

Line 4921: okc_k_lines_b okc

4917: oks.trxn_extension_id,
4918: oks.payment_type,
4919: okc.bill_to_site_use_id
4920: FROM oks_k_lines_b oks,
4921: okc_k_lines_b okc
4922: WHERE oks.dnz_chr_id = p_chr_id
4923: AND oks.cle_id = okc.id
4924: AND okc.date_cancelled IS NULL --4735326
4925: AND oks.trxn_extension_id IS NOT NULL; --process only lines with credit cards

Line 5536: FROM okc_k_lines_b lines

5532: CURSOR top_line_grp_csr (p_hdr_id NUMBER) IS
5533: SELECT lines.id, lines.lse_id lse_id, lines.cle_id,
5534: lines.start_date, lines.end_date, lines.line_number, date_terminated,
5535: lines.price_negotiated
5536: FROM okc_k_lines_b lines
5537: WHERE lines.dnz_chr_id = p_hdr_id
5538: AND lines.cle_id IS NULL
5539: AND lines.lse_id IN (1, 12, 19, 46)
5540: AND lines.date_terminated IS NULL -- added by mkhayer 11/21/2002.

Line 5550: FROM okc_k_lines_b lines , oks_k_lines_b oks

5546: CURSOR top_line_grp_csr (p_hdr_id NUMBER) IS
5547: SELECT lines.id, lines.lse_id lse_id, lines.cle_id,
5548: lines.start_date, lines.end_date, lines.line_number, date_terminated,
5549: lines.price_negotiated, oks.credit_amount, oks.suppressed_credit, oks.override_amount
5550: FROM okc_k_lines_b lines , oks_k_lines_b oks
5551: WHERE lines.dnz_chr_id = p_hdr_id
5552: AND lines.cle_id IS NULL
5553: AND lines.lse_id IN (1, 12, 19, 46)
5554: AND lines.date_terminated IS NULL -- added by mkhayer 11/21/2002.

Line 5563: FROM okc_k_lines_b lines

5559: -- Sub Line information
5560: CURSOR line_grp_csr (p_hdr_id NUMBER, p_cle_id NUMBER) IS
5561: SELECT lines.id, lines.lse_id lse_id, lines.cle_id,
5562: lines.start_date, lines.end_date, lines.price_negotiated, lines.line_number, date_terminated
5563: FROM okc_k_lines_b lines
5564: WHERE lines.dnz_chr_id = p_hdr_id
5565: AND lines.cle_id = p_cle_id
5566: AND lines.lse_id IN (7, 8, 9, 10, 11, 13, 18, 25, 35)
5567: AND lines.date_terminated IS NULL -- uncommented by mkhayer

Line 5621: FROM okc_k_lines_b

5617: AND date_completed IS NOT NULL;
5618:
5619: CURSOR get_line_price(l_line_id NUMBER) IS
5620: SELECT price_negotiated
5621: FROM okc_k_lines_b
5622: WHERE id = l_line_id
5623: AND lse_id IN (7, 8, 9, 10, 11, 18, 25, 35, 46);
5624:
5625:

Line 6308: FROM okc_k_lines_b cle,

6304:
6305: /*** Get all service lines for given Contract header id ***/
6306: CURSOR l_csr_get_service_line_id(p_chr_id NUMBER) IS
6307: SELECT cle.id, sts.ste_code sts_code
6308: FROM okc_k_lines_b cle,
6309: okc_statuses_b sts
6310: WHERE cle.dnz_chr_id = p_chr_id
6311: AND sts.code = cle.sts_code
6312: AND cle.lse_id IN (1, 19)

Line 6320: FROM okc_k_lines_b

6316: /*** Get customer id for all the above service lines ***/
6317: -- object1_id1 of CAN rule
6318: CURSOR l_csr_get_customer_id(p_chr_id NUMBER, l_service_id NUMBER) IS
6319: SELECT CUST_ACCT_ID
6320: FROM okc_k_lines_b
6321: WHERE dnz_chr_id = p_chr_id
6322: AND id = l_service_id;
6323:
6324:

Line 6336: FROM okc_k_lines_b

6332:
6333: /*** Get all product lines and item lines for each service line ***/
6334: CURSOR l_csr_get_product_line_id IS
6335: SELECT id, start_date, lse_id
6336: FROM okc_k_lines_b
6337: WHERE cle_id = l_service_id
6338: AND lse_id IN (9, 25, 7) -- 7 added for bug#2430496
6339: AND date_cancelled IS NULL --Changes [llc]
6340: ;

Line 6699: FROM okc_k_lines_b

6695: -- lines that have been terminated (with termination date less than sysdate)
6696:
6697: CURSOR get_cust_acct_lines(p_chr_id NUMBER) IS
6698: SELECT cust_acct_id, id, ship_to_site_use_id, line_number
6699: FROM okc_k_lines_b
6700: WHERE dnz_chr_id = p_chr_id
6701: AND cust_acct_id IS NOT NULL
6702: AND chr_id IS NOT NULL
6703: AND date_cancelled IS NULL --Changes [llc]

Line 7244: FROM okc_k_lines_b

7240: ) IS
7241: -- Get sublines with covered products
7242: CURSOR get_cp_lines IS
7243: SELECT id subline_id, start_date, end_date, line_number subline_number, cle_id
7244: FROM okc_k_lines_b
7245: WHERE dnz_chr_id = p_chr_id
7246: AND cle_id IS NOT NULL
7247: AND lse_id = 9
7248: AND date_cancelled IS NULL ; --Changes [llc]

Line 7269: FROM okc_k_lines_b

7265:
7266: -- See if the cp dates fall within the the subscription line start date, end date
7267: CURSOR check_effectivity(subscr_line_Id NUMBER, cpStartDate DATE, cpEndDate DATE) IS
7268: SELECT sts_code
7269: FROM okc_k_lines_b
7270: WHERE id = subscr_line_Id AND (cpStartDate BETWEEN start_date AND end_date)
7271: AND (cpEndDate BETWEEN start_date AND end_date) AND lse_id = 46 AND cle_id IS NULL ;
7272:
7273: l_inst_id NUMBER;

Line 7347: FROM okc_k_lines_b

7343: x_return_status OUT NOCOPY VARCHAR2) IS
7344:
7345: CURSOR get_subscr_line IS
7346: SELECT id ,date_terminated -- Added "date_terminated" for Bug 5702660
7347: FROM okc_k_lines_b
7348: WHERE dnz_chr_id = p_chr_id
7349: AND lse_id = 46
7350: AND date_cancelled IS NULL --Changes [llc]
7351: ;

Line 7433: FROM okc_k_lines_b

7429: x_return_status OUT NOCOPY VARCHAR2) IS
7430:
7431: CURSOR get_subscr_lines IS
7432: SELECT id
7433: FROM okc_k_lines_b
7434: WHERE dnz_chr_id = p_chr_id
7435: AND lse_id = 46
7436: AND date_cancelled IS NULL --Changes [llc]
7437: ;

Line 7452: FROM OKC_K_LINES_B

7448: -- Get the ship to rule for the shipable subscription line.
7449: -- OBJECT1_ID1 of STO for lines only
7450: CURSOR get_ship_to_rule(cleId NUMBER) IS
7451: SELECT SHIP_TO_SITE_USE_ID
7452: FROM OKC_K_LINES_B
7453: WHERE id = cleId;
7454:
7455:
7456: -- Get the ship to address for shipable subscription line.

Line 7548: FROM okc_k_lines_b

7544: x_return_status OUT NOCOPY VARCHAR2) IS
7545:
7546: CURSOR Get_Covered_Prod(l_chr_id NUMBER) IS
7547: SELECT id
7548: FROM okc_k_lines_b
7549: WHERE lse_id IN (9, 25)
7550: AND dnz_chr_id = l_chr_id
7551: AND date_cancelled IS NULL --Changes [llc]
7552: ;

Line 7740: FROM okc_k_lines_b a, oks_k_lines_b b

7736:
7737: -- Gets old line id's that have a lock
7738: CURSOR get_old_line_id(l_old_chr_id NUMBER) IS
7739: SELECT b.cle_id
7740: FROM okc_k_lines_b a, oks_k_lines_b b
7741: WHERE a.id = b.cle_id
7742: AND b.dnz_chr_id = l_old_chr_id
7743: AND b.dnz_chr_id = a.dnz_chr_id
7744: AND a.lse_id IN (12, 13)

Line 7753: FROM okc_k_lines_b

7749: --and b.prorate is not null; -- prorate is not mandatory
7750:
7751: CURSOR get_new_line_id(l_chr_id NUMBER, l_old_line_id NUMBER) IS
7752: SELECT id
7753: FROM okc_k_lines_b
7754: WHERE dnz_chr_id = l_chr_id
7755: AND lse_id IN (12, 13)
7756: AND orig_system_id1 = l_old_line_id;
7757:

Line 7946: FROM okc_k_lines_b b, okc_statuses_b s

7942: AND e.ste_code NOT IN ('ACTIVE', 'SIGNED', 'HOLD', 'EXPIRED');
7943:
7944: CURSOR cur_lines_status IS
7945: SELECT b.id, b.line_number, s.ste_code
7946: FROM okc_k_lines_b b, okc_statuses_b s
7947: WHERE dnz_chr_id = p_chr_id
7948: AND cle_id IS NULL
7949: AND s.code = b.sts_code;
7950:

Line 7954: FROM okc_k_lines_b b, okc_statuses_b s

7950:
7951:
7952: CURSOR cur_sublines_status(p_cle_id NUMBER) IS
7953: SELECT b.id, b.line_number, s.ste_code
7954: FROM okc_k_lines_b b, okc_statuses_b s
7955: WHERE cle_id = p_cle_id
7956: AND s.code = b.sts_code
7957: AND s.ste_code = 'CANCELLED';
7958:

Line 7968: FROM okc_operation_lines a, okc_operation_instances b, okc_class_operations c, okc_k_lines_b d

7964:
7965:
7966: CURSOR cur_is_topline_renewed (p_cle_id NUMBER) IS
7967: SELECT subject_cle_id
7968: FROM okc_operation_lines a, okc_operation_instances b, okc_class_operations c, okc_k_lines_b d
7969: WHERE a.object_cle_id = d.id
7970: AND a.object_chr_id = d.dnz_chr_id
7971: AND d.cle_id = p_cle_id -- should be a top line id
7972: AND a.object_chr_id = p_chr_id

Line 7986: FROM okc_k_lines_b

7982: WHERE id = p_contract_id;
7983:
7984: CURSOR cur_target_line_number (p_cle_id NUMBER) IS
7985: SELECT line_number
7986: FROM okc_k_lines_b
7987: WHERE id = p_cle_id;
7988:
7989: CURSOR cur_target_subline_number (p_cle_id NUMBER) IS
7990: SELECT lines2.line_number || '.' || lines1.line_number

Line 7991: FROM okc_k_lines_b lines1, okc_k_lines_b lines2

7987: WHERE id = p_cle_id;
7988:
7989: CURSOR cur_target_subline_number (p_cle_id NUMBER) IS
7990: SELECT lines2.line_number || '.' || lines1.line_number
7991: FROM okc_k_lines_b lines1, okc_k_lines_b lines2
7992: WHERE lines1.id = p_cle_id
7993: AND lines1.cle_id = lines2.id;
7994:
7995:

Line 8225: FROM OKC_K_ITEMS oti,okc_k_lines_b okc,okc_k_lines_b subline

8221:
8222: CURSOR check_covd_qty(p_chr_id number)
8223: IS
8224: SELECT OKC.LINE_NUMBER line_number,subline.line_number sub_line_number
8225: FROM OKC_K_ITEMS oti,okc_k_lines_b okc,okc_k_lines_b subline
8226: WHERE okc.lse_id IN (1,20)
8227: AND oti.dnz_chr_id =p_chr_id
8228: AND okc.chr_id = subline.dnz_chr_id
8229: AND oti.NUMBER_of_items IS NULL