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_STATUSES_B

Line 111: --| OKC_STATUSES_B | X | | | | | |

107: --| OKS_INSTANCE_TEMP | X | | | | | |
108: --+---------------------------------+---+---+---+---+---+----------------------+
109: --| OKC_STATUSES_V | X | | | | | |
110: --+---------------------------------+---+---+---+---+---+----------------------+
111: --| OKC_STATUSES_B | X | | | | | |
112: --+---------------------------------+---+---+---+---+---+----------------------+
113: --| CS_COUNTERS | X | | | | | |
114: --+---------------------------------+---+---+---+---+---+----------------------+
115: --| CS_COUNTER_GROUPS | X | | | | | |

Line 428: From Okc_statuses_b

424: Function get_ste_code(p_sts_code Varchar2) return Varchar2
425: Is
426: CUrsor l_ste_csr Is
427: Select ste_code
428: From Okc_statuses_b
429: Where code = p_sts_code;
430: l_ste_code Varchar2(30);
431: Begin
432: Open l_ste_csr;

Line 534: From Okc_statuses_b

530: Function get_status_code(p_ste_code Varchar2) return Varchar2
531: Is
532: CUrsor l_sts_csr Is
533: Select code
534: From Okc_statuses_b
535: Where ste_code = p_ste_code
536: And default_yn = 'Y';
537: l_sts_code Varchar2(30);
538: Begin

Line 559: FROM okc_statuses_b

555: x_sts_code OUT NOCOPY VARCHAR2
556: ) IS
557: CURSOR l_ste_csr IS
558: SELECT code
559: FROM okc_statuses_b
560: WHERE ste_code = p_ste_code
561: AND default_yn = 'Y';
562:
563: CURSOR l_sts_csr IS

Line 565: FROM okc_statuses_b a, okc_statuses_b b

561: AND default_yn = 'Y';
562:
563: CURSOR l_sts_csr IS
564: SELECT a.code, a.ste_code
565: FROM okc_statuses_b a, okc_statuses_b b
566: WHERE b.code = p_sts_code
567: AND b.ste_code = a.ste_code
568: AND a.default_yn = 'Y';
569:

Line 1871: okc_statuses_b st,

1867:
1868: FROM okc_k_headers_all_b kh,
1869: oks_k_headers_b ks,
1870: oks_instance_k_dtls_temp temp,
1871: okc_statuses_b st,
1872: okc_governances gov
1873: WHERE kh.ID = temp.contract_id
1874: AND temp.new_contract_id is not null
1875: AND st.code = kh.sts_code

Line 1931: From okc_statuses_b

1927: AND rle_code = 'VENDOR'
1928: AND jtot_object_code = 'OKX_SALEPERS';
1929: Cursor l_ste_csr(p_sts_code varchar2) Is
1930: Select ste_code
1931: From okc_statuses_b
1932: WHere code = p_sts_code;
1933:
1934: Cursor l_warranty_csr(p_hdr_Id Number) Is
1935: Select lse_id

Line 3292: okc_statuses_b st,

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
3295: AND temp.new_serviceline_id IS NOT NULL
3296: AND itm.cle_id = kl.ID

Line 3822: okc_statuses_b st,

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
3825: AND temp.new_subline_id IS NOT NULL
3826: AND itm.cle_id = kl.ID

Line 4500: , Okc_statuses_b St

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
4504: And Ki.cle_id = Line.Id

Line 4522: , Okc_statuses_b St

4518: ,ks.period_start
4519: From OKs_instance_k_dtls_temp temp
4520: , Okc_k_headers_all_b Kh
4521: , Okc_k_headers_all_b OKH
4522: , Okc_statuses_b St
4523: , Okc_statuses_b OSt
4524: , Okc_k_lines_b Kl
4525: , Oks_k_headers_b Ks
4526: Where Kh.Id = temp.new_contract_id

Line 4523: , Okc_statuses_b OSt

4519: From OKs_instance_k_dtls_temp temp
4520: , Okc_k_headers_all_b Kh
4521: , Okc_k_headers_all_b OKH
4522: , Okc_statuses_b St
4523: , Okc_statuses_b OSt
4524: , Okc_k_lines_b Kl
4525: , Oks_k_headers_b Ks
4526: Where Kh.Id = temp.new_contract_id
4527: And OKH.Id = temp.contract_id

Line 5929: , Okc_statuses_b St

5925: ,St.ste_code
5926: ,line.start_date
5927: From Oks_instance_k_dtls_temp temp
5928: , okc_k_lines_b line
5929: , Okc_statuses_b St
5930: Where line.id = temp.Topline_id
5931: And temp.contract_id = p_contract_id
5932: And St.code = line.sts_code;
5933:

Line 5942: , Okc_statuses_b St

5938: , St.ste_code
5939: , Kh.start_date
5940: From OKs_instance_k_dtls_temp temp
5941: , Okc_k_headers_all_b Kh
5942: , Okc_statuses_b St
5943: Where Kh.Id = temp.contract_id
5944: And St.code = Kh.sts_code;
5945: contract_id okc_datatypes.numbertabtyp;
5946: org_id okc_datatypes.numbertabtyp;

Line 6140: okc_statuses_b st,

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,
6141: okc_statuses_b Hst,
6142: oks_k_lines_b ks1,
6143: oks_k_lines_b ks2,
6144: okc_k_lines_b kl2,

Line 6141: okc_statuses_b Hst,

6137: okc_k_headers_all_b kh,
6138: oks_k_headers_b ks,
6139: okc_k_lines_b kl,
6140: okc_statuses_b st,
6141: okc_statuses_b Hst,
6142: oks_k_lines_b ks1,
6143: oks_k_lines_b ks2,
6144: okc_k_lines_b kl2,
6145: oks_instance_temp tmp,

Line 6234: okc_statuses_b st,

6230: okc_k_lines_b sl,
6231: okc_k_lines_b Tl,
6232: oks_k_lines_b okl,
6233: oks_k_lines_b okl1,
6234: okc_statuses_b st,
6235: okc_k_party_roles_b party,
6236: oks_instance_temp tmp,
6237: okc_statuses_b Hst
6238: WHERE tmp.trf = 'Y'

Line 6237: okc_statuses_b Hst

6233: oks_k_lines_b okl1,
6234: okc_statuses_b st,
6235: okc_k_party_roles_b party,
6236: oks_instance_temp tmp,
6237: okc_statuses_b Hst
6238: WHERE tmp.trf = 'Y'
6239: AND ki.object1_id1 = to_char(tmp.old_customer_product_id)
6240: AND ki.jtot_object1_code = 'OKX_CUSTPROD'
6241: AND ki.dnz_chr_id = kh.ID

Line 6310: okc_statuses_b st,

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,
6312: okc_k_lines_b tl,
6313: okc_k_party_roles_b party,
6314: Okc_statuses_b Hst,

Line 6314: Okc_statuses_b Hst,

6310: okc_statuses_b st,
6311: oks_instance_temp tmp,
6312: okc_k_lines_b tl,
6313: okc_k_party_roles_b party,
6314: Okc_statuses_b Hst,
6315: Okc_statuses_b Lst
6316: WHERE tmp.trm = 'Y'
6317: AND ki.object1_id1 = to_char(tmp.old_customer_product_id)
6318: AND ki.jtot_object1_code = 'OKX_CUSTPROD'

Line 6315: Okc_statuses_b Lst

6311: oks_instance_temp tmp,
6312: okc_k_lines_b tl,
6313: okc_k_party_roles_b party,
6314: Okc_statuses_b Hst,
6315: Okc_statuses_b Lst
6316: WHERE tmp.trm = 'Y'
6317: AND ki.object1_id1 = to_char(tmp.old_customer_product_id)
6318: AND ki.jtot_object1_code = 'OKX_CUSTPROD'
6319: AND ki.dnz_chr_id = kh.ID

Line 6375: okc_statuses_b st,

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,
6376: csi_counter_associations ctrAsc,
6377: oks_instance_temp tmp,
6378: okc_k_party_roles_b party,
6379: okc_statuses_b Hst,

Line 6379: okc_statuses_b Hst,

6375: okc_statuses_b st,
6376: csi_counter_associations ctrAsc,
6377: oks_instance_temp tmp,
6378: okc_k_party_roles_b party,
6379: okc_statuses_b Hst,
6380: okc_statuses_b Lst
6381: WHERE tmp.trm = 'Y'
6382: AND ki.object1_id1 = to_char(ctrAsc.counter_id)
6383: AND ctrAsc.source_object_id = tmp.old_customer_product_id

Line 6380: okc_statuses_b Lst

6376: csi_counter_associations ctrAsc,
6377: oks_instance_temp tmp,
6378: okc_k_party_roles_b party,
6379: okc_statuses_b Hst,
6380: okc_statuses_b Lst
6381: WHERE tmp.trm = 'Y'
6382: AND ki.object1_id1 = to_char(ctrAsc.counter_id)
6383: AND ctrAsc.source_object_id = tmp.old_customer_product_id
6384: And ctrAsc.source_object_code = 'CP'

Line 6443: okc_statuses_b st,

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,
6445: okc_k_lines_b tl,
6446: oks_k_lines_v ksl,
6447: oks_k_lines_b ks11

Line 6651: , Okc_statuses_b St

6647: Select Distinct temp.topline_id
6648: ,St.ste_code
6649: From Oks_instance_k_dtls_temp temp
6650: , okc_k_lines_b line
6651: , Okc_statuses_b St
6652: Where line.id = temp.Topline_id
6653: And temp.contract_id = p_contract_id
6654: And St.code = line.sts_code;
6655:

Line 6663: , Okc_statuses_b St

6659: , kh.inv_organization_id
6660: , St.ste_code
6661: From OKs_instance_k_dtls_temp temp
6662: , Okc_k_headers_all_b Kh
6663: , Okc_statuses_b St
6664: Where Kh.Id = temp.contract_id
6665: And St.code = Kh.sts_code;
6666:
6667: