APPS.OKC_OPPORTUNITY_PVT dependencies on OKC_K_ITEMS

Line 575: l_object1_id1 okc_k_items.object1_id1%Type;

571: l_cle_id_tbl id_tbl;
572: l_price_unit_tbl price_unit_tbl;
573: l_price_negotiated_tbl price_negotiated_tbl;
574: l_currency_code_tbl currency_code_tbl;*/
575: l_object1_id1 okc_k_items.object1_id1%Type;
576: l_object1_id2 okc_k_items.object1_id2%Type;
577: l_uom_code okc_k_items.uom_code%Type;
578: l_number_of_items okc_k_items.number_of_items%Type;
579: l_rel_id_tbl id_tbl;

Line 576: l_object1_id2 okc_k_items.object1_id2%Type;

572: l_price_unit_tbl price_unit_tbl;
573: l_price_negotiated_tbl price_negotiated_tbl;
574: l_currency_code_tbl currency_code_tbl;*/
575: l_object1_id1 okc_k_items.object1_id1%Type;
576: l_object1_id2 okc_k_items.object1_id2%Type;
577: l_uom_code okc_k_items.uom_code%Type;
578: l_number_of_items okc_k_items.number_of_items%Type;
579: l_rel_id_tbl id_tbl;
580: l_rel_lead_line_id_tbl Lead_Line_Id_tbl;

Line 577: l_uom_code okc_k_items.uom_code%Type;

573: l_price_negotiated_tbl price_negotiated_tbl;
574: l_currency_code_tbl currency_code_tbl;*/
575: l_object1_id1 okc_k_items.object1_id1%Type;
576: l_object1_id2 okc_k_items.object1_id2%Type;
577: l_uom_code okc_k_items.uom_code%Type;
578: l_number_of_items okc_k_items.number_of_items%Type;
579: l_rel_id_tbl id_tbl;
580: l_rel_lead_line_id_tbl Lead_Line_Id_tbl;
581: --

Line 578: l_number_of_items okc_k_items.number_of_items%Type;

574: l_currency_code_tbl currency_code_tbl;*/
575: l_object1_id1 okc_k_items.object1_id1%Type;
576: l_object1_id2 okc_k_items.object1_id2%Type;
577: l_uom_code okc_k_items.uom_code%Type;
578: l_number_of_items okc_k_items.number_of_items%Type;
579: l_rel_id_tbl id_tbl;
580: l_rel_lead_line_id_tbl Lead_Line_Id_tbl;
581: --
582: l_header_rec as_opportunity_pub.header_rec_type;

Line 612: okc_k_items itm,

608: from okc_k_lines_b cle
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

Line 648: okc_k_items itm,

644: itm.object1_id2,
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

Line 677: okc_k_items itm,

673: from okc_k_lines_b cle
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

Line 700: cursor exp_rel_csr (p_cle_id okc_k_items.cle_id%TYPE)is

696: and rel.rty_code = g_rty_code))
697: connect by prior cle.id = cle.cle_id;
698: */
699: --
700: cursor exp_rel_csr (p_cle_id okc_k_items.cle_id%TYPE)is
701: select object1_id1, object1_id2
702: from okc_k_rel_objs rel
703: where rel.cle_id = p_cle_id
704: and rel.rty_code = 'OPPEXPSCONTRACT';

Line 706: /* cursor item_csr (p_cle_id okc_k_items.cle_id%TYPE)is

702: from okc_k_rel_objs rel
703: where rel.cle_id = p_cle_id
704: and rel.rty_code = 'OPPEXPSCONTRACT';
705: --
706: /* cursor item_csr (p_cle_id okc_k_items.cle_id%TYPE)is
707: select itm.object1_id1,
708: itm.object1_id2,
709: itm.uom_code,
710: itm.number_of_items

Line 711: from okc_k_items itm,

707: select itm.object1_id1,
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'

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: /*

Line 1166: from okc_k_items

1162: and jou.object_user_code = 'OKX_MTL_SYSTEM_ITEM';
1163: /*
1164: cursor itm_csr is
1165: select 'x'
1166: from okc_k_items
1167: where dnz_chr_id = p_contract_id
1168: -- and jtot_object1_code = 'OKX_LICPROD';
1169: and jtot_object1_code = 'OKX_MTL_SYSTEM_ITEMS';
1170: */