APPS.OKC_OPPORTUNITY_PVT dependencies on OKC_STATUSES_B

Line 613: okc_statuses_b sts,

609: where level = 1
610: start with cle.id in (select cle2.id
611: from okc_k_lines_b cle2,
612: okc_k_items itm,
613: okc_statuses_b sts,
614: jtf_object_usages jou
615: where cle2.dnz_chr_id = p_contract_id
616: and cle2.date_renewed is null
617: and cle2.sts_code = sts.code

Line 649: okc_statuses_b sts,

645: itm.uom_code,
646: itm.number_of_items
647: from okc_k_lines_b cle,
648: okc_k_items itm,
649: okc_statuses_b sts,
650: jtf_object_usages jou
651: where cle.chr_id = p_contract_id
652: and cle.date_renewed is null
653: and cle.sts_code = sts.code

Line 678: okc_statuses_b sts,

674: where level = 1
675: start with cle.id in (select cle2.id
676: from okc_k_lines_b cle2,
677: okc_k_items itm,
678: okc_statuses_b sts,
679: jtf_object_usages jou
680: where cle2.dnz_chr_id = p_contract_id
681: and cle2.date_renewed is null
682: and cle2.sts_code = sts.code

Line 1135: okc_statuses_b sts

1131: scs.create_opp_yn,
1132: sts.ste_code
1133: from okc_k_headers_b chrb,
1134: okc_subclasses_b scs,
1135: okc_statuses_b sts
1136: where chrb.id = p_contract_id
1137: and scs.code = chrb.scs_code
1138: and sts.code = chrb.sts_code;
1139: k_rec k_csr%ROWTYPE;

Line 1175: okc_statuses_b sts

1171: --
1172: cursor line_csr is
1173: select 'x'
1174: from okc_k_lines_b cle,
1175: okc_statuses_b sts
1176: -- where cle.dnz_chr_id = p_contract_id
1177: where cle.chr_id = p_contract_id
1178: and cle.sts_code = sts.code
1179: and sts.ste_code in ('ACTIVE', 'SIGNED');