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

Line 268: From mtl_system_items_kfv mtl, okc_k_items_v itm

264: Is
265:
266:
267: Select mtl.concatenated_segments, sys.name
268: From mtl_system_items_kfv mtl, okc_k_items_v itm
269: ,csi_item_instances csi, csi_systems_tl sys
270: where itm.cle_id = P_line_id
271: And itm.jtot_object1_code = 'OKX_CUSTPROD'
272: And csi.instance_id = itm.object1_id1

Line 283: , okc_k_items_v itm

279:
280: Cursor l_counter_csr Is
281: Select mtl.concatenated_segments
282: From mtl_system_items_kfv mtl, csi_counter_associations ctrAsc
283: , okc_k_items_v itm
284: ,csi_item_instances csi
285: Where itm.cle_id = P_line_id
286: And ctrAsc.counter_id = itm.object1_id1
287: And csi.instance_id = ctrAsc.source_object_id

Line 1429: From OKC_K_ITEMS KI

1425: , Coverage_terminate_amount(KI.CLE_ID,Ks1.transfer_option,p_new_account_id,p_transaction_date,tmp.instance_id) Coverage_terminate_amount --coverage terminate amount
1426: , Coverage_term_full_amount(KI.Cle_id,Ks1.transfer_option,p_new_account_id,p_transaction_date,tmp.instance_id,kl.end_date) Coverage_full_amount
1427: , Get_date_terminated(St.ste_code,p_transaction_date,kl.start_date, kl.end_date)
1428:
1429: From OKC_K_ITEMS KI
1430: , OKC_K_HEADERS_all_B KH
1431: , OKC_K_LINES_B KL
1432: , OKC_STATUSES_B ST
1433: , Oks_Instance_k_dtls_temp tmp

Line 1484: From OKC_K_ITEMS KI

1480: , 0
1481: , 0
1482: , 0
1483: , Get_date_terminated(St.ste_code,p_transaction_date,kl.start_date, Kl.end_date)
1484: From OKC_K_ITEMS KI
1485: , OKC_K_HEADERS_ALL_B KH
1486: , OKC_K_LINES_B KL
1487: , OKC_STATUSES_B ST
1488: , Oks_Instance_k_dtls_temp tmp

Line 1536: From OKC_K_ITEMS KI

1532: , 0
1533: , 0
1534: , 0
1535: , Get_date_terminated(St.ste_code,p_transaction_date,kl.start_date, Kl.end_date)
1536: From OKC_K_ITEMS KI
1537: ,OKC_K_HEADERS_ALL_B KH
1538: ,OKC_K_LINES_B KL
1539: ,OKC_STATUSES_B ST
1540: ,csi_counter_associations ctrAsc

Line 1590: From OKC_K_ITEMS_V KI

1586: , 0
1587: , 0
1588: , 0
1589: , null
1590: From OKC_K_ITEMS_V KI
1591: , OKC_K_HEADERS_ALL_B KH
1592: , OKC_K_LINES_B KL
1593: , OKC_STATUSES_B ST
1594: , OKS_K_LINES_B KS

Line 1939: l_object_code okc_k_items.jtot_object1_code%TYPE;

1935: AND t.LANGUAGE = USERENV ('LANG')
1936: AND b.inventory_item_id = p_product_item
1937: AND ROWNUM < 2;
1938:
1939: l_object_code okc_k_items.jtot_object1_code%TYPE;
1940: l_object1_id1 okc_k_items.object1_id1%TYPE;
1941: l_object1_id2 okc_k_items.object1_id2%TYPE;
1942: l_no_of_items okc_k_items.number_of_items%TYPE;
1943: l_name VARCHAR2 (2000);

Line 1940: l_object1_id1 okc_k_items.object1_id1%TYPE;

1936: AND b.inventory_item_id = p_product_item
1937: AND ROWNUM < 2;
1938:
1939: l_object_code okc_k_items.jtot_object1_code%TYPE;
1940: l_object1_id1 okc_k_items.object1_id1%TYPE;
1941: l_object1_id2 okc_k_items.object1_id2%TYPE;
1942: l_no_of_items okc_k_items.number_of_items%TYPE;
1943: l_name VARCHAR2 (2000);
1944: l_desc VARCHAR2 (2000);

Line 1941: l_object1_id2 okc_k_items.object1_id2%TYPE;

1937: AND ROWNUM < 2;
1938:
1939: l_object_code okc_k_items.jtot_object1_code%TYPE;
1940: l_object1_id1 okc_k_items.object1_id1%TYPE;
1941: l_object1_id2 okc_k_items.object1_id2%TYPE;
1942: l_no_of_items okc_k_items.number_of_items%TYPE;
1943: l_name VARCHAR2 (2000);
1944: l_desc VARCHAR2 (2000);
1945: l_formatted_invoice_text VARCHAR2 (2000);

Line 1942: l_no_of_items okc_k_items.number_of_items%TYPE;

1938:
1939: l_object_code okc_k_items.jtot_object1_code%TYPE;
1940: l_object1_id1 okc_k_items.object1_id1%TYPE;
1941: l_object1_id2 okc_k_items.object1_id2%TYPE;
1942: l_no_of_items okc_k_items.number_of_items%TYPE;
1943: l_name VARCHAR2 (2000);
1944: l_desc VARCHAR2 (2000);
1945: l_formatted_invoice_text VARCHAR2 (2000);
1946: BEGIN

Line 2247: okc_k_items im,

2243:
2244: FROM okc_k_lines_b sl,
2245: oks_k_lines_b tls,
2246: oks_k_lines_b tls1,
2247: okc_k_items im,
2248: csi_item_instances csi
2249:
2250: WHERE sl.id = p_line_id
2251: AND sl.id = im.cle_id

Line 2559: , okc_k_items itm

2555:
2556: Cursor get_name_csr Is
2557: Select fnd_flex_server.get_kfv_concat_segs_by_rowid('COMPACT', 401, 'SERV', 101, mtl.rowid), description
2558: From Mtl_system_items_b mtl
2559: , okc_k_items itm
2560: Where mtl.inventory_item_id = itm.object1_id1
2561: and mtl.organization_id = itm.object1_id2
2562: And itm.cle_id = p_line_id;
2563:

Line 2588: okc_k_items_v itm

2584:
2585: CURSOR get_prod_name_csr IS
2586: SELECT mtl.concatenated_segments
2587: From mtl_system_items_kfv mtl,
2588: okc_k_items_v itm
2589: ,csi_item_instances csi
2590: where itm.object1_id1 = p_object1_id1
2591: And itm.jtot_object1_code = 'OKX_CUSTPROD'
2592: And csi.instance_id = itm.object1_id1