APPS.OKC_OPPORTUNITY_PVT dependencies on JTF_OBJECT_USAGES

Line 614: jtf_object_usages jou

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
618: and itm.cle_id = cle.id

Line 650: jtf_object_usages jou

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
654: and itm.cle_id = cle.id

Line 679: jtf_object_usages jou

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
683: and itm.cle_id = cle.id

Line 712: jtf_object_usages jou

708: itm.object1_id2,
709: itm.uom_code,
710: itm.number_of_items
711: from okc_k_items itm,
712: jtf_object_usages jou
713: where itm.cle_id = p_cle_id
714: -- and itm.jtot_object1_code = 'OKX_LICPROD'
715: -- and itm.jtot_object1_code = 'OKX_MTL_SYSTEM_ITEMS'
716: and itm.jtot_object1_code = jou.object_code

Line 1159: from okc_k_items itm, jtf_object_usages jou

1155: --
1156: -- item should be of usage OKX_MTL_SYSTEM_ITEM
1157: cursor itm_csr is
1158: select 'x'
1159: from okc_k_items itm, jtf_object_usages jou
1160: where itm.dnz_chr_id = p_contract_id
1161: and itm.jtot_object1_code = jou.object_code
1162: and jou.object_user_code = 'OKX_MTL_SYSTEM_ITEM';
1163: /*