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 775: FROM okc_k_items

771: SELECT jtot_object1_code,
772: object1_id1,
773: object1_id2,
774: number_of_items
775: FROM okc_k_items
776: WHERE cle_id = p_cle_id;
777: */
778: CURSOR l_inv_csr (p_product_item NUMBER)
779: IS

Line 788: l_object_code okc_k_items.jtot_object1_code%TYPE;

784: AND t.LANGUAGE = USERENV ('LANG')
785: AND b.inventory_item_id = p_product_item
786: AND ROWNUM < 2;
787:
788: l_object_code okc_k_items.jtot_object1_code%TYPE;
789: l_object1_id1 okc_k_items.object1_id1%TYPE;
790: l_object1_id2 okc_k_items.object1_id2%TYPE;
791: l_no_of_items okc_k_items.number_of_items%TYPE;
792: l_name VARCHAR2 (2000);

Line 789: l_object1_id1 okc_k_items.object1_id1%TYPE;

785: AND b.inventory_item_id = p_product_item
786: AND ROWNUM < 2;
787:
788: l_object_code okc_k_items.jtot_object1_code%TYPE;
789: l_object1_id1 okc_k_items.object1_id1%TYPE;
790: l_object1_id2 okc_k_items.object1_id2%TYPE;
791: l_no_of_items okc_k_items.number_of_items%TYPE;
792: l_name VARCHAR2 (2000);
793: l_desc VARCHAR2 (2000);

Line 790: l_object1_id2 okc_k_items.object1_id2%TYPE;

786: AND ROWNUM < 2;
787:
788: l_object_code okc_k_items.jtot_object1_code%TYPE;
789: l_object1_id1 okc_k_items.object1_id1%TYPE;
790: l_object1_id2 okc_k_items.object1_id2%TYPE;
791: l_no_of_items okc_k_items.number_of_items%TYPE;
792: l_name VARCHAR2 (2000);
793: l_desc VARCHAR2 (2000);
794: l_formatted_invoice_text VARCHAR2 (2000);

Line 791: l_no_of_items okc_k_items.number_of_items%TYPE;

787:
788: l_object_code okc_k_items.jtot_object1_code%TYPE;
789: l_object1_id1 okc_k_items.object1_id1%TYPE;
790: l_object1_id2 okc_k_items.object1_id2%TYPE;
791: l_no_of_items okc_k_items.number_of_items%TYPE;
792: l_name VARCHAR2 (2000);
793: l_desc VARCHAR2 (2000);
794: l_formatted_invoice_text VARCHAR2 (2000);
795: BEGIN

Line 1325: FROM okc_k_items

1321:
1322: CURSOR service_item (l_line_id NUMBER)
1323: IS
1324: SELECT object1_id1
1325: FROM okc_k_items
1326: WHERE cle_id = l_line_id AND jtot_object1_code LIKE 'OKX_SYSITEM';
1327:
1328: -- if date_completed is not null then it's billed.
1329: CURSOR get_date_complete (l_line_id NUMBER)

Line 6632: okc_k_items a

6628: FROM okc_operation_instances op,
6629: okc_operation_lines ol,
6630: okc_class_operations cl,
6631: okc_subclasses_b sl,
6632: okc_k_items a
6633: WHERE ol.oie_id = op.ID
6634: AND op.cop_id = cl.ID
6635: AND cl.cls_code = sl.cls_code
6636: AND sl.code = 'SERVICE'

Line 6641: from okc_k_items b

6637: AND cl.opn_code = p_source_code
6638: AND ol.object_cle_id = p_line_id
6639: AND a.cle_id = ol.subject_cle_id
6640: AND a.object1_id1 = (Select b.object1_id1
6641: from okc_k_items b
6642: where b.jtot_object1_code = 'OKX_CUSTPROD'
6643: and b.cle_id = p_target_line_id)
6644: AND a.jtot_object1_code = 'OKX_CUSTPROD';
6645:

Line 7150: UPDATE okc_k_items

7146: l_list_price := p_kdtl_tbl (l_ctr).service_unit_price;
7147: l_covd_rec.list_price := p_kdtl_tbl (l_ctr).service_unit_price;
7148: END IF; ---warranty flag = 'W'
7149:
7150: UPDATE okc_k_items
7151: SET number_of_items = l_old_qty
7152: WHERE cle_id = p_kdtl_tbl (l_ctr).object_line_id;
7153:
7154: UPDATE okc_k_lines_b

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

9537:
9538: CURSOR l_toplines_csr (p_chr_id NUMBER, p_service_item_id NUMBER)
9539: IS
9540: SELECT kl.ID cle_id
9541: FROM okc_k_lines_b kl, okc_k_items ki, okc_statuses_b st
9542: WHERE kl.dnz_chr_id = p_chr_id
9543: AND kl.lse_id IN (1, 14, 19)
9544: AND kl.ID = ki.cle_id
9545: AND ki.object1_id1 = TO_CHAR (p_service_item_id)

Line 14948: okc_k_items ki

14944: IS
14945: SELECT t.description NAME, b.concatenated_segments description
14946: FROM mtl_system_items_b_kfv b,
14947: mtl_system_items_tl t,
14948: okc_k_items ki
14949: WHERE ki.cle_id = p_serv_line_id
14950: AND b.inventory_item_id = TO_CHAR (ki.object1_id1)
14951: AND t.inventory_item_id = b.inventory_item_id
14952: AND t.organization_id = b.organization_id

Line 15946: UPDATE okc_k_items

15942: --errorout_n('in update lse_id'||p_kdtl_tbl(l_ctr).lse_id);
15943: -- For Warranty lines instance qty is updated, no repricing done.
15944: IF p_kdtl_tbl (l_ctr).lse_id = 18
15945: THEN --Warranty
15946: UPDATE okc_k_items
15947: SET number_of_items = p_kdtl_tbl (l_ctr).new_quantity
15948: WHERE cle_id = p_kdtl_tbl (l_ctr).object_line_id;
15949:
15950: l_inst_dtls_tbl (l_ptr).transaction_date :=

Line 16033: UPDATE okc_k_items

16029:
16030: --If amount billed is null, update instance qty and reprice.
16031: IF l_billed_amount IS NULL
16032: THEN
16033: UPDATE okc_k_items
16034: SET number_of_items =
16035: p_kdtl_tbl (l_ctr).new_quantity
16036: WHERE cle_id = p_kdtl_tbl (l_ctr).object_line_id;
16037:

Line 16736: UPDATE okc_k_items

16732: RAISE g_exception_halt_validation;
16733: END IF;
16734: END IF;
16735: ELSE --Billed amount is less than service amount
16736: UPDATE okc_k_items
16737: SET number_of_items =
16738: p_kdtl_tbl (l_ctr).new_quantity
16739: WHERE cle_id = p_kdtl_tbl (l_ctr).object_line_id;
16740: