APPS.OKS_QA_DATA_INTEGRITY dependencies on OKS_SUBSCR_HEADER_B

Line 7254: FROM okc_k_items a, oks_subscr_header_b b

7250: -- Checks if the item it's covering is a subscritpion item and then it gets
7251: -- the item instance
7252: CURSOR get_item_inst(subline_id NUMBER) IS
7253: SELECT a.object1_id1
7254: FROM okc_k_items a, oks_subscr_header_b b
7255: WHERE a.cle_id = subline_id
7256: AND b.instance_id = a.object1_id1;
7257:
7258:

Line 7262: FROM okc_k_headers_all_b a, oks_subscr_header_b b

7258:
7259: -- is item instance valid
7260: CURSOR get_subscr(instId NUMBER) IS
7261: SELECT b.dnz_chr_id subscr_chr_id, b.cle_id subscr_line_id
7262: FROM okc_k_headers_all_b a, oks_subscr_header_b b
7263: WHERE b.instance_id = instId AND b.dnz_chr_id = a.id AND
7264: (a.id = p_chr_id OR (a.id <> p_chr_id AND a.sts_code IN ('ACTIVE', 'SIGNED')) );
7265:
7266: -- See if the cp dates fall within the the subscription line start date, end date

Line 7355: FROM oks_subscr_header_b a

7351: ;
7352:
7353: CURSOR is_tangible_item(cleId NUMBER) IS
7354: SELECT a.id
7355: FROM oks_subscr_header_b a
7356: WHERE a.cle_id = cleId AND a.dnz_chr_id = p_chr_id
7357: AND a.fulfillment_channel = 'OM';
7358:
7359: CURSOR get_subscr_element(oshId NUMBER, cleId NUMBER) IS

Line 7563: FROM oks_subscr_header_b b

7559: l_item_inst Get_Item_Inst%ROWTYPE;
7560:
7561: CURSOR is_subscr_item(l_inst_id NUMBER) IS
7562: SELECT b.instance_id
7563: FROM oks_subscr_header_b b
7564: WHERE b.instance_id = l_inst_id;
7565:
7566: l_subscr_inst_id is_subscr_item%ROWTYPE;
7567: