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 4550: FROM okc_k_items_v

4546: l_cimv_rec_in OKC_CONTRACT_ITEM_PUB.cimv_rec_type;
4547: l_cimv_rec_out OKC_CONTRACT_ITEM_PUB.cimv_rec_type;
4548: CURSOR item_cur IS
4549: SELECT id
4550: FROM okc_k_items_v
4551: WHERE cle_id = p_cle_id;
4552: BEGIN
4553: OPEN item_cur;
4554: FETCH item_cur INTO l_cimv_rec_in.id;

Line 5066: FROM okc_k_items

5062: SELECT jtot_object1_code
5063: , object1_id1
5064: , object1_id2
5065: , number_of_items
5066: FROM okc_k_items
5067: WHERE cle_id = p_cle_id;
5068: l_object_code okc_k_items.jtot_object1_code%TYPE;
5069: l_object1_id1 okc_k_items.object1_id1%TYPE;
5070: l_object1_id2 okc_k_items.object1_id2%TYPE;

Line 5068: l_object_code okc_k_items.jtot_object1_code%TYPE;

5064: , object1_id2
5065: , number_of_items
5066: FROM okc_k_items
5067: WHERE cle_id = p_cle_id;
5068: l_object_code okc_k_items.jtot_object1_code%TYPE;
5069: l_object1_id1 okc_k_items.object1_id1%TYPE;
5070: l_object1_id2 okc_k_items.object1_id2%TYPE;
5071: l_no_of_items okc_k_items.number_of_items%TYPE;
5072: l_name VARCHAR2(2000);

Line 5069: l_object1_id1 okc_k_items.object1_id1%TYPE;

5065: , number_of_items
5066: FROM okc_k_items
5067: WHERE cle_id = p_cle_id;
5068: l_object_code okc_k_items.jtot_object1_code%TYPE;
5069: l_object1_id1 okc_k_items.object1_id1%TYPE;
5070: l_object1_id2 okc_k_items.object1_id2%TYPE;
5071: l_no_of_items okc_k_items.number_of_items%TYPE;
5072: l_name VARCHAR2(2000);
5073: l_desc VARCHAR2(2000);

Line 5070: l_object1_id2 okc_k_items.object1_id2%TYPE;

5066: FROM okc_k_items
5067: WHERE cle_id = p_cle_id;
5068: l_object_code okc_k_items.jtot_object1_code%TYPE;
5069: l_object1_id1 okc_k_items.object1_id1%TYPE;
5070: l_object1_id2 okc_k_items.object1_id2%TYPE;
5071: l_no_of_items okc_k_items.number_of_items%TYPE;
5072: l_name VARCHAR2(2000);
5073: l_desc VARCHAR2(2000);
5074: l_formatted_invoice_text VARCHAR2(2000);

Line 5071: l_no_of_items okc_k_items.number_of_items%TYPE;

5067: WHERE cle_id = p_cle_id;
5068: l_object_code okc_k_items.jtot_object1_code%TYPE;
5069: l_object1_id1 okc_k_items.object1_id1%TYPE;
5070: l_object1_id2 okc_k_items.object1_id2%TYPE;
5071: l_no_of_items okc_k_items.number_of_items%TYPE;
5072: l_name VARCHAR2(2000);
5073: l_desc VARCHAR2(2000);
5074: l_formatted_invoice_text VARCHAR2(2000);
5075: BEGIN

Line 5292: FROM okc_k_items

5288: WHERE cle_id = p_cle_id; */
5289:
5290: CURSOR item_cur (p_cle_id IN NUMBER) IS
5291: SELECT object1_id1, object1_id2, jtot_object1_code
5292: FROM okc_k_items
5293: WHERE cle_id = p_cle_id;
5294:
5295: item_rec item_cur%ROWTYPE;
5296:

Line 6218: FROM okc_k_items

6214:
6215: CURSOR l_get_item_id(p_cle_id IN NUMBER)
6216: IS
6217: SELECT object1_id1, object1_id2, dnz_chr_id, uom_code
6218: FROM okc_k_items
6219: WHERE cle_id = p_cle_id;
6220:
6221:
6222: CURSOR l_csr_Get_party_sites(p_party_id IN NUMBER)

Line 6270: l_uom OKC_K_ITEMS.uom_code%TYPE;

6266: l_inv_item_id OKX_system_items_v.id1%TYPE;
6267: l_inv_organization_id NUMBER;
6268: l_dnz_chr_id NUMBER;
6269: l_party_id NUMBER;
6270: l_uom OKC_K_ITEMS.uom_code%TYPE;
6271: l_party_site_id HZ_PARTY_SITES.party_site_id%TYPE;
6272: l_rgp_id OKC_RULE_GROUPS_B.id%TYPE;
6273: l_cust_acct_id OKX_CUSTOMER_ACCOUNTS_V.id1%TYPE;
6274:

Line 6624: SET owner_party_source_table = 'OKC_K_ITEMS_B',

6620: -- dbms_output.put_line('x_msg_data = '||x_msg_data);
6621: --- dbms_output.put_line('instance_id = '||p_instance_rec.instance_id);
6622:
6623: /* UPDATE csi_item_instances
6624: SET owner_party_source_table = 'OKC_K_ITEMS_B',
6625: security_group_id = p_cle_id
6626: WHERE instance_id = p_instance_rec.instance_id;
6627: */
6628:

Line 7854: FROM okc_k_items

7850: AND lse_id IN (9, 25);
7851:
7852: CURSOR get_okc_item_qty_csr (p_item_cle_id NUMBER) IS
7853: SELECT object1_id1, number_of_items
7854: FROM okc_k_items
7855: WHERE cle_id = p_item_cle_id;
7856:
7857: get_okc_item_qty_rec get_okc_item_qty_csr%ROWTYPE;
7858:

Line 7887: UPDATE okc_k_items

7883: CLOSE get_csi_item_qty_csr;
7884:
7885: IF NVL(get_csi_item_qty_rec.quantity, 0) > NVL(get_okc_item_qty_rec.number_of_items, 0)
7886: THEN
7887: UPDATE okc_k_items
7888: SET number_of_items = get_csi_item_qty_rec.quantity
7889: WHERE cle_id = get_all_instances_rec.id;
7890:
7891: --calling reprice