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_AUTH_UTIL_PVT dependencies on OKC_K_ITEMS

Line 4010: FROM okc_k_items_v

4006: l_cimv_rec_in OKC_CONTRACT_ITEM_PUB.cimv_rec_type;
4007: l_cimv_rec_out OKC_CONTRACT_ITEM_PUB.cimv_rec_type;
4008: CURSOR item_cur IS
4009: SELECT id
4010: FROM okc_k_items_v
4011: WHERE cle_id = p_cle_id;
4012: BEGIN
4013: OPEN item_cur;
4014: FETCH item_cur INTO l_cimv_rec_in.id;

Line 4526: FROM okc_k_items

4522: SELECT jtot_object1_code
4523: , object1_id1
4524: , object1_id2
4525: , number_of_items
4526: FROM okc_k_items
4527: WHERE cle_id = p_cle_id;
4528: l_object_code okc_k_items.jtot_object1_code%TYPE;
4529: l_object1_id1 okc_k_items.object1_id1%TYPE;
4530: l_object1_id2 okc_k_items.object1_id2%TYPE;

Line 4528: l_object_code okc_k_items.jtot_object1_code%TYPE;

4524: , object1_id2
4525: , number_of_items
4526: FROM okc_k_items
4527: WHERE cle_id = p_cle_id;
4528: l_object_code okc_k_items.jtot_object1_code%TYPE;
4529: l_object1_id1 okc_k_items.object1_id1%TYPE;
4530: l_object1_id2 okc_k_items.object1_id2%TYPE;
4531: l_no_of_items okc_k_items.number_of_items%TYPE;
4532: l_name VARCHAR2(2000);

Line 4529: l_object1_id1 okc_k_items.object1_id1%TYPE;

4525: , number_of_items
4526: FROM okc_k_items
4527: WHERE cle_id = p_cle_id;
4528: l_object_code okc_k_items.jtot_object1_code%TYPE;
4529: l_object1_id1 okc_k_items.object1_id1%TYPE;
4530: l_object1_id2 okc_k_items.object1_id2%TYPE;
4531: l_no_of_items okc_k_items.number_of_items%TYPE;
4532: l_name VARCHAR2(2000);
4533: l_desc VARCHAR2(2000);

Line 4530: l_object1_id2 okc_k_items.object1_id2%TYPE;

4526: FROM okc_k_items
4527: WHERE cle_id = p_cle_id;
4528: l_object_code okc_k_items.jtot_object1_code%TYPE;
4529: l_object1_id1 okc_k_items.object1_id1%TYPE;
4530: l_object1_id2 okc_k_items.object1_id2%TYPE;
4531: l_no_of_items okc_k_items.number_of_items%TYPE;
4532: l_name VARCHAR2(2000);
4533: l_desc VARCHAR2(2000);
4534: l_formatted_invoice_text VARCHAR2(2000);

Line 4531: l_no_of_items okc_k_items.number_of_items%TYPE;

4527: WHERE cle_id = p_cle_id;
4528: l_object_code okc_k_items.jtot_object1_code%TYPE;
4529: l_object1_id1 okc_k_items.object1_id1%TYPE;
4530: l_object1_id2 okc_k_items.object1_id2%TYPE;
4531: l_no_of_items okc_k_items.number_of_items%TYPE;
4532: l_name VARCHAR2(2000);
4533: l_desc VARCHAR2(2000);
4534: l_formatted_invoice_text VARCHAR2(2000);
4535: BEGIN

Line 4751: FROM okc_k_items

4747: WHERE cle_id = p_cle_id; */
4748:
4749: CURSOR item_cur (p_cle_id IN NUMBER) IS
4750: SELECT object1_id1, object1_id2, jtot_object1_code
4751: FROM okc_k_items
4752: WHERE cle_id = p_cle_id;
4753:
4754: item_rec item_cur%ROWTYPE;
4755:

Line 5604: FROM okc_k_items

5600:
5601: CURSOR l_get_item_id(p_cle_id IN NUMBER)
5602: IS
5603: SELECT object1_id1, object1_id2, dnz_chr_id, uom_code
5604: FROM okc_k_items
5605: WHERE cle_id = p_cle_id;
5606:
5607:
5608: CURSOR l_csr_Get_party_sites(p_party_id IN NUMBER)

Line 5656: l_uom OKC_K_ITEMS.uom_code%TYPE;

5652: l_inv_item_id OKX_system_items_v.id1%TYPE;
5653: l_inv_organization_id NUMBER;
5654: l_dnz_chr_id NUMBER;
5655: l_party_id NUMBER;
5656: l_uom OKC_K_ITEMS.uom_code%TYPE;
5657: l_party_site_id HZ_PARTY_SITES.party_site_id%TYPE;
5658: l_rgp_id OKC_RULE_GROUPS_B.id%TYPE;
5659: l_cust_acct_id OKX_CUSTOMER_ACCOUNTS_V.id1%TYPE;
5660:

Line 6004: SET owner_party_source_table = 'OKC_K_ITEMS_B',

6000: -- dbms_output.put_line('x_msg_data = '||x_msg_data);
6001: --- dbms_output.put_line('instance_id = '||p_instance_rec.instance_id);
6002:
6003: /* UPDATE csi_item_instances
6004: SET owner_party_source_table = 'OKC_K_ITEMS_B',
6005: security_group_id = p_cle_id
6006: WHERE instance_id = p_instance_rec.instance_id;
6007: */
6008:

Line 7190: FROM okc_k_items

7186: AND lse_id IN (9, 25);
7187:
7188: CURSOR get_okc_item_qty_csr (p_item_cle_id NUMBER) IS
7189: SELECT object1_id1, number_of_items
7190: FROM okc_k_items
7191: WHERE cle_id = p_item_cle_id;
7192:
7193: get_okc_item_qty_rec get_okc_item_qty_csr%ROWTYPE;
7194:

Line 7223: UPDATE okc_k_items

7219: CLOSE get_csi_item_qty_csr;
7220:
7221: IF NVL(get_csi_item_qty_rec.quantity, 0) > NVL(get_okc_item_qty_rec.number_of_items, 0)
7222: THEN
7223: UPDATE okc_k_items
7224: SET number_of_items = get_csi_item_qty_rec.quantity
7225: WHERE cle_id = get_all_instances_rec.id;
7226:
7227: --calling reprice