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

Line 21: --| OKC_K_ITEMS | X | X | | | |X |

17: --| MTL_SYSTEM_ITEMS_TL | X | | | | | |
18: --+---------------------------------+---+---+---+---+---+----------------------+
19: --| MTL_SYSTEM_ITEMS_B_KFV | X | | | | | |
20: --+---------------------------------+---+---+---+---+---+----------------------+
21: --| OKC_K_ITEMS | X | X | | | |X |
22: --+---------------------------------+---+---+---+---+---+----------------------+
23: --| OKS_RENEW_UTIL_PVT | | | | | |X |
24: --+---------------------------------+---+---+---+---+---+----------------------+
25: --| OKC_K_VERS_NUMBERS | X | | X | | | |

Line 101: --| OKC_K_ITEMS_V | X | | | | | |

97: --| OKC_OPERATION_LINES | X | | | | | |
98: --+---------------------------------+---+---+---+---+---+----------------------+
99: --| OKC_OPERATION_INSTANCES | X | | | | | |
100: --+---------------------------------+---+---+---+---+---+----------------------+
101: --| OKC_K_ITEMS_V | X | | | | | |
102: --+---------------------------------+---+---+---+---+---+----------------------+
103: --| OKC_K_LINES_V | X | | | | | |
104: --+---------------------------------+---+---+---+---+---+----------------------+
105: --| OKC_K_PARTY_ROLES_B | X | | | | | |

Line 912: l_object_code okc_k_items.jtot_object1_code%TYPE;

908: AND t.LANGUAGE = USERENV ('LANG')
909: AND b.inventory_item_id = p_product_item
910: AND ROWNUM < 2;
911:
912: l_object_code okc_k_items.jtot_object1_code%TYPE;
913: l_object1_id1 okc_k_items.object1_id1%TYPE;
914: l_object1_id2 okc_k_items.object1_id2%TYPE;
915: l_no_of_items okc_k_items.number_of_items%TYPE;
916: l_name VARCHAR2 (2000);

Line 913: l_object1_id1 okc_k_items.object1_id1%TYPE;

909: AND b.inventory_item_id = p_product_item
910: AND ROWNUM < 2;
911:
912: l_object_code okc_k_items.jtot_object1_code%TYPE;
913: l_object1_id1 okc_k_items.object1_id1%TYPE;
914: l_object1_id2 okc_k_items.object1_id2%TYPE;
915: l_no_of_items okc_k_items.number_of_items%TYPE;
916: l_name VARCHAR2 (2000);
917: l_desc VARCHAR2 (2000);

Line 914: l_object1_id2 okc_k_items.object1_id2%TYPE;

910: AND ROWNUM < 2;
911:
912: l_object_code okc_k_items.jtot_object1_code%TYPE;
913: l_object1_id1 okc_k_items.object1_id1%TYPE;
914: l_object1_id2 okc_k_items.object1_id2%TYPE;
915: l_no_of_items okc_k_items.number_of_items%TYPE;
916: l_name VARCHAR2 (2000);
917: l_desc VARCHAR2 (2000);
918: l_formatted_invoice_text VARCHAR2 (2000);

Line 915: l_no_of_items okc_k_items.number_of_items%TYPE;

911:
912: l_object_code okc_k_items.jtot_object1_code%TYPE;
913: l_object1_id1 okc_k_items.object1_id1%TYPE;
914: l_object1_id2 okc_k_items.object1_id2%TYPE;
915: l_no_of_items okc_k_items.number_of_items%TYPE;
916: l_name VARCHAR2 (2000);
917: l_desc VARCHAR2 (2000);
918: l_formatted_invoice_text VARCHAR2 (2000);
919: BEGIN

Line 3285: okc_k_items itm,

3281:
3282:
3283: FROM oks_instance_k_dtls_temp temp,
3284: okc_k_lines_b kl,
3285: okc_k_items itm,
3286: oks_k_lines_v ks,
3287: okc_statuses_b st,
3288: okc_k_headers_all_b kh
3289: WHERE temp.topline_id = kl.ID

Line 3542: -- create item record in okc_k_items

3538: g_module_current || 'oks_mass_update.create_contract_Line',
3539: 'After insert into okc_k_lines_tl table ');
3540: END IF;
3541:
3542: -- create item record in okc_k_items
3543: FORALL i IN 1 .. l_tabsize
3544: INSERT INTO okc_k_items
3545: (ID,
3546: cle_id,

Line 3544: INSERT INTO okc_k_items

3540: END IF;
3541:
3542: -- create item record in okc_k_items
3543: FORALL i IN 1 .. l_tabsize
3544: INSERT INTO okc_k_items
3545: (ID,
3546: cle_id,
3547: --chr_id,
3548: cle_id_for,

Line 3602: 'After insert into okc_k_items table ');

3598: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3599: THEN
3600: fnd_log.STRING (fnd_log.level_event,
3601: g_module_current || 'oks_mass_update.create_contract_Line',
3602: 'After insert into okc_k_items table ');
3603: END IF;
3604:
3605: -- create oks line
3606: FORALL i IN 1 .. l_tabsize

Line 3815: okc_k_items itm,

3811:
3812: FROM oks_instance_k_dtls_temp temp,
3813: okc_k_lines_b kl,
3814: okc_k_lines_b kl1,
3815: okc_k_items itm,
3816: oks_k_lines_v ks,
3817: okc_statuses_b st,
3818: oks_k_headers_b kh
3819: WHERE temp.subline_id = kl.ID

Line 4025: -- create item record in okc_k_items

4021: g_module_current || 'oks_mass_update.create_contract_Line',
4022: 'after insert into okc_k_lines_tl table');
4023: END IF;
4024:
4025: -- create item record in okc_k_items
4026: FORALL i IN 1 .. l_tabsize
4027: INSERT INTO okc_k_items
4028: (ID,
4029: cle_id,

Line 4027: INSERT INTO okc_k_items

4023: END IF;
4024:
4025: -- create item record in okc_k_items
4026: FORALL i IN 1 .. l_tabsize
4027: INSERT INTO okc_k_items
4028: (ID,
4029: cle_id,
4030: --chr_id,
4031: cle_id_for,

Line 4084: 'after insert into okc_k_items table');

4080: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4081: THEN
4082: fnd_log.STRING (fnd_log.level_event,
4083: g_module_current || 'oks_mass_update.create_contract_Line',
4084: 'after insert into okc_k_items table');
4085: END IF;
4086:
4087: -- create oks line
4088: FORALL i IN 1 .. l_tabsize

Line 4494: , Okc_k_items Ki

4490: From Oks_instance_k_dtls_temp temp
4491: , okc_k_lines_b line
4492: , Okc_k_lines_b Kl
4493: , oks_k_lines_b Ks
4494: , Okc_k_items Ki
4495: , Okc_statuses_b St
4496: Where line.id = temp.new_serviceline_id
4497: And Kl.Id = temp.topline_id
4498: And Ks.cle_id = line.Id

Line 6119: FROM okc_k_items ki,

6115: Kh.authoring_org_id,
6116: NVL(P_credit_option
6117: ,OKS_IB_UTIL_PVT.get_credit_option(party.object1_id1,kh.authoring_org_id,tmp.transaction_date)),
6118: Kh.inv_organization_id
6119: FROM okc_k_items ki,
6120: okc_k_headers_all_b kh,
6121: oks_k_headers_b ks,
6122: okc_k_lines_b kl,
6123: okc_statuses_b st,

Line 6210: FROM okc_k_items ki,

6206: NVL(P_credit_option
6207: ,OKS_IB_UTIL_PVT.get_credit_option(party.object1_id1,kh.authoring_org_id,tmp.transaction_date)),
6208: Kh.inv_organization_id
6209:
6210: FROM okc_k_items ki,
6211: okc_k_headers_all_b kh,
6212: oks_k_headers_b ks,
6213: okc_k_lines_b sl,
6214: okc_k_lines_b Tl,

Line 6290: FROM okc_k_items ki,

6286: kh.authoring_org_id,
6287: NVL(P_credit_option
6288: ,OKS_IB_UTIL_PVT.get_credit_option(party.object1_id1,kh.authoring_org_id,tmp.transaction_date)),
6289: Kh.inv_organization_id
6290: FROM okc_k_items ki,
6291: okc_k_headers_all_b kh,
6292: okc_k_lines_b kl,
6293: okc_statuses_b st,
6294: oks_instance_temp tmp,

Line 6354: FROM okc_k_items ki,

6350: Kh.inv_organization_id
6351:
6352:
6353:
6354: FROM okc_k_items ki,
6355: okc_k_headers_all_b kh,
6356: okc_k_lines_b kl,
6357: okc_k_lines_b tl,
6358: okc_statuses_b st,

Line 6423: FROM okc_k_items ki,

6419: kl.line_number
6420:
6421:
6422:
6423: FROM okc_k_items ki,
6424: okc_k_headers_all_b kh,
6425: okc_k_lines_b kl,
6426: okc_statuses_b st,
6427: oks_instance_temp tmp,