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

Line 28: FROM okc_k_lines_b kl, okc_k_items ki, okc_statuses_b ks

24:
25: CURSOR l_service_csr
26: IS
27: SELECT /*+ leading (kl) use_nl (kl ki) */ kl.ID cle_id
28: FROM okc_k_lines_b kl, okc_k_items ki, okc_statuses_b ks
29: WHERE kl.dnz_chr_id = p_chrid
30: AND kl.lse_id IN (1, 14, 19)
31: AND kl.ID = ki.cle_id
32: AND ki.object1_id1 = TO_CHAR (p_invserviceid)

Line 735: FROM okc_k_items

731: SELECT jtot_object1_code,
732: object1_id1,
733: object1_id2,
734: number_of_items
735: FROM okc_k_items
736: WHERE cle_id = p_cle_id;
737: */
738: CURSOR l_inv_csr (p_product_item NUMBER)
739: IS

Line 748: l_object_code okc_k_items.jtot_object1_code%TYPE;

744: AND t.LANGUAGE = USERENV ('LANG')
745: AND b.inventory_item_id = p_product_item
746: AND ROWNUM < 2;
747:
748: l_object_code okc_k_items.jtot_object1_code%TYPE;
749: l_object1_id1 okc_k_items.object1_id1%TYPE;
750: l_object1_id2 okc_k_items.object1_id2%TYPE;
751: l_no_of_items okc_k_items.number_of_items%TYPE;
752: l_name VARCHAR2 (2000);

Line 749: l_object1_id1 okc_k_items.object1_id1%TYPE;

745: AND b.inventory_item_id = p_product_item
746: AND ROWNUM < 2;
747:
748: l_object_code okc_k_items.jtot_object1_code%TYPE;
749: l_object1_id1 okc_k_items.object1_id1%TYPE;
750: l_object1_id2 okc_k_items.object1_id2%TYPE;
751: l_no_of_items okc_k_items.number_of_items%TYPE;
752: l_name VARCHAR2 (2000);
753: l_desc VARCHAR2 (2000);

Line 750: l_object1_id2 okc_k_items.object1_id2%TYPE;

746: AND ROWNUM < 2;
747:
748: l_object_code okc_k_items.jtot_object1_code%TYPE;
749: l_object1_id1 okc_k_items.object1_id1%TYPE;
750: l_object1_id2 okc_k_items.object1_id2%TYPE;
751: l_no_of_items okc_k_items.number_of_items%TYPE;
752: l_name VARCHAR2 (2000);
753: l_desc VARCHAR2 (2000);
754: l_formatted_invoice_text VARCHAR2 (2000);

Line 751: l_no_of_items okc_k_items.number_of_items%TYPE;

747:
748: l_object_code okc_k_items.jtot_object1_code%TYPE;
749: l_object1_id1 okc_k_items.object1_id1%TYPE;
750: l_object1_id2 okc_k_items.object1_id2%TYPE;
751: l_no_of_items okc_k_items.number_of_items%TYPE;
752: l_name VARCHAR2 (2000);
753: l_desc VARCHAR2 (2000);
754: l_formatted_invoice_text VARCHAR2 (2000);
755: BEGIN

Line 1285: FROM okc_k_items

1281:
1282: CURSOR service_item (l_line_id NUMBER)
1283: IS
1284: SELECT object1_id1
1285: FROM okc_k_items
1286: WHERE cle_id = l_line_id AND jtot_object1_code LIKE 'OKX_SYSITEM';
1287:
1288: -- if date_completed is not null then it's billed.
1289: CURSOR get_date_complete (l_line_id NUMBER)

Line 6464: okc_k_items a

6460: FROM okc_operation_instances op,
6461: okc_operation_lines ol,
6462: okc_class_operations cl,
6463: okc_subclasses_b sl,
6464: okc_k_items a
6465: WHERE ol.oie_id = op.ID
6466: AND op.cop_id = cl.ID
6467: AND cl.cls_code = sl.cls_code
6468: AND sl.code = 'SERVICE'

Line 6473: from okc_k_items b

6469: AND cl.opn_code = p_source_code
6470: AND ol.object_cle_id = p_line_id
6471: AND a.cle_id = ol.subject_cle_id
6472: AND a.object1_id1 = (Select b.object1_id1
6473: from okc_k_items b
6474: where b.jtot_object1_code = 'OKX_CUSTPROD'
6475: and b.cle_id = p_target_line_id)
6476: AND a.jtot_object1_code = 'OKX_CUSTPROD';
6477:

Line 6969: UPDATE okc_k_items

6965: l_list_price := p_kdtl_tbl (l_ctr).service_unit_price;
6966: l_covd_rec.list_price := p_kdtl_tbl (l_ctr).service_unit_price;
6967: END IF; ---warranty flag = 'W'
6968:
6969: UPDATE okc_k_items
6970: SET number_of_items = l_old_qty
6971: WHERE cle_id = p_kdtl_tbl (l_ctr).object_line_id;
6972:
6973: UPDATE okc_k_lines_b

Line 9310: FROM okc_k_lines_b kl, okc_k_items ki, okc_statuses_b st

9306:
9307: CURSOR l_toplines_csr (p_chr_id NUMBER, p_service_item_id NUMBER)
9308: IS
9309: SELECT kl.ID cle_id
9310: FROM okc_k_lines_b kl, okc_k_items ki, okc_statuses_b st
9311: WHERE kl.dnz_chr_id = p_chr_id
9312: AND kl.lse_id IN (1, 14, 19)
9313: AND kl.ID = ki.cle_id
9314: AND ki.object1_id1 = TO_CHAR (p_service_item_id)

Line 14663: okc_k_items ki

14659: IS
14660: SELECT t.description NAME, b.concatenated_segments description
14661: FROM mtl_system_items_b_kfv b,
14662: mtl_system_items_tl t,
14663: okc_k_items ki
14664: WHERE ki.cle_id = p_serv_line_id
14665: AND b.inventory_item_id = TO_CHAR (ki.object1_id1)
14666: AND t.inventory_item_id = b.inventory_item_id
14667: AND t.organization_id = b.organization_id

Line 15648: UPDATE okc_k_items

15644: --errorout_n('in update lse_id'||p_kdtl_tbl(l_ctr).lse_id);
15645: -- For Warranty lines instance qty is updated, no repricing done.
15646: IF p_kdtl_tbl (l_ctr).lse_id = 18
15647: THEN --Warranty
15648: UPDATE okc_k_items
15649: SET number_of_items = p_kdtl_tbl (l_ctr).new_quantity
15650: WHERE cle_id = p_kdtl_tbl (l_ctr).object_line_id;
15651:
15652: l_inst_dtls_tbl (l_ptr).transaction_date :=

Line 15735: UPDATE okc_k_items

15731:
15732: --If amount billed is null, update instance qty and reprice.
15733: IF l_billed_amount IS NULL
15734: THEN
15735: UPDATE okc_k_items
15736: SET number_of_items =
15737: p_kdtl_tbl (l_ctr).new_quantity
15738: WHERE cle_id = p_kdtl_tbl (l_ctr).object_line_id;
15739:

Line 16438: UPDATE okc_k_items

16434: RAISE g_exception_halt_validation;
16435: END IF;
16436: END IF;
16437: ELSE --Billed amount is less than service amount
16438: UPDATE okc_k_items
16439: SET number_of_items =
16440: p_kdtl_tbl (l_ctr).new_quantity
16441: WHERE cle_id = p_kdtl_tbl (l_ctr).object_line_id;
16442: