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 916: l_object_code okc_k_items.jtot_object1_code%TYPE;

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

Line 917: l_object1_id1 okc_k_items.object1_id1%TYPE;

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

Line 918: l_object1_id2 okc_k_items.object1_id2%TYPE;

914: AND ROWNUM < 2;
915:
916: l_object_code okc_k_items.jtot_object1_code%TYPE;
917: l_object1_id1 okc_k_items.object1_id1%TYPE;
918: l_object1_id2 okc_k_items.object1_id2%TYPE;
919: l_no_of_items okc_k_items.number_of_items%TYPE;
920: l_name VARCHAR2 (2000);
921: l_desc VARCHAR2 (2000);
922: l_formatted_invoice_text VARCHAR2 (2000);

Line 919: l_no_of_items okc_k_items.number_of_items%TYPE;

915:
916: l_object_code okc_k_items.jtot_object1_code%TYPE;
917: l_object1_id1 okc_k_items.object1_id1%TYPE;
918: l_object1_id2 okc_k_items.object1_id2%TYPE;
919: l_no_of_items okc_k_items.number_of_items%TYPE;
920: l_name VARCHAR2 (2000);
921: l_desc VARCHAR2 (2000);
922: l_formatted_invoice_text VARCHAR2 (2000);
923: BEGIN

Line 3290: okc_k_items itm,

3286:
3287:
3288: FROM oks_instance_k_dtls_temp temp,
3289: okc_k_lines_b kl,
3290: okc_k_items itm,
3291: oks_k_lines_v ks,
3292: okc_statuses_b st,
3293: okc_k_headers_all_b kh
3294: WHERE temp.topline_id = kl.ID

Line 3547: -- create item record in okc_k_items

3543: g_module_current || 'oks_mass_update.create_contract_Line',
3544: 'After insert into okc_k_lines_tl table ');
3545: END IF;
3546:
3547: -- create item record in okc_k_items
3548: FORALL i IN 1 .. l_tabsize
3549: INSERT INTO okc_k_items
3550: (ID,
3551: cle_id,

Line 3549: INSERT INTO okc_k_items

3545: END IF;
3546:
3547: -- create item record in okc_k_items
3548: FORALL i IN 1 .. l_tabsize
3549: INSERT INTO okc_k_items
3550: (ID,
3551: cle_id,
3552: --chr_id,
3553: cle_id_for,

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

3603: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
3604: THEN
3605: fnd_log.STRING (fnd_log.level_event,
3606: g_module_current || 'oks_mass_update.create_contract_Line',
3607: 'After insert into okc_k_items table ');
3608: END IF;
3609:
3610: -- create oks line
3611: FORALL i IN 1 .. l_tabsize

Line 3820: okc_k_items itm,

3816:
3817: FROM oks_instance_k_dtls_temp temp,
3818: okc_k_lines_b kl,
3819: okc_k_lines_b kl1,
3820: okc_k_items itm,
3821: oks_k_lines_v ks,
3822: okc_statuses_b st,
3823: oks_k_headers_b kh
3824: WHERE temp.subline_id = kl.ID

Line 4030: -- create item record in okc_k_items

4026: g_module_current || 'oks_mass_update.create_contract_Line',
4027: 'after insert into okc_k_lines_tl table');
4028: END IF;
4029:
4030: -- create item record in okc_k_items
4031: FORALL i IN 1 .. l_tabsize
4032: INSERT INTO okc_k_items
4033: (ID,
4034: cle_id,

Line 4032: INSERT INTO okc_k_items

4028: END IF;
4029:
4030: -- create item record in okc_k_items
4031: FORALL i IN 1 .. l_tabsize
4032: INSERT INTO okc_k_items
4033: (ID,
4034: cle_id,
4035: --chr_id,
4036: cle_id_for,

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

4085: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)
4086: THEN
4087: fnd_log.STRING (fnd_log.level_event,
4088: g_module_current || 'oks_mass_update.create_contract_Line',
4089: 'after insert into okc_k_items table');
4090: END IF;
4091:
4092: -- create oks line
4093: FORALL i IN 1 .. l_tabsize

Line 4499: , Okc_k_items Ki

4495: From Oks_instance_k_dtls_temp temp
4496: , okc_k_lines_b line
4497: , Okc_k_lines_b Kl
4498: , oks_k_lines_b Ks
4499: , Okc_k_items Ki
4500: , Okc_statuses_b St
4501: Where line.id = temp.new_serviceline_id
4502: And Kl.Id = temp.topline_id
4503: And Ks.cle_id = line.Id

Line 6136: FROM okc_k_items ki,

6132: Kh.authoring_org_id,
6133: NVL(P_credit_option
6134: ,OKS_IB_UTIL_PVT.get_credit_option(party.object1_id1,kh.authoring_org_id,tmp.transaction_date)),
6135: Kh.inv_organization_id
6136: FROM okc_k_items ki,
6137: okc_k_headers_all_b kh,
6138: oks_k_headers_b ks,
6139: okc_k_lines_b kl,
6140: okc_statuses_b st,

Line 6227: FROM okc_k_items ki,

6223: NVL(P_credit_option
6224: ,OKS_IB_UTIL_PVT.get_credit_option(party.object1_id1,kh.authoring_org_id,tmp.transaction_date)),
6225: Kh.inv_organization_id
6226:
6227: FROM okc_k_items ki,
6228: okc_k_headers_all_b kh,
6229: oks_k_headers_b ks,
6230: okc_k_lines_b sl,
6231: okc_k_lines_b Tl,

Line 6307: FROM okc_k_items ki,

6303: kh.authoring_org_id,
6304: NVL(P_credit_option
6305: ,OKS_IB_UTIL_PVT.get_credit_option(party.object1_id1,kh.authoring_org_id,tmp.transaction_date)),
6306: Kh.inv_organization_id
6307: FROM okc_k_items ki,
6308: okc_k_headers_all_b kh,
6309: okc_k_lines_b kl,
6310: okc_statuses_b st,
6311: oks_instance_temp tmp,

Line 6371: FROM okc_k_items ki,

6367: Kh.inv_organization_id
6368:
6369:
6370:
6371: FROM okc_k_items ki,
6372: okc_k_headers_all_b kh,
6373: okc_k_lines_b kl,
6374: okc_k_lines_b tl,
6375: okc_statuses_b st,

Line 6440: FROM okc_k_items ki,

6436: kl.line_number
6437:
6438:
6439:
6440: FROM okc_k_items ki,
6441: okc_k_headers_all_b kh,
6442: okc_k_lines_b kl,
6443: okc_statuses_b st,
6444: oks_instance_temp tmp,