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 1867: okc_statuses_b st,

1863:
1864: FROM okc_k_headers_all_b kh,
1865: oks_k_headers_b ks,
1866: oks_instance_k_dtls_temp temp,
1867: okc_statuses_b st,
1868: okc_governances gov
1869: WHERE kh.ID = temp.contract_id
1870: AND temp.new_contract_id is not null
1871: AND st.code = kh.sts_code

Line 1926: From okc_statuses_b

1922: AND rle_code = 'VENDOR'
1923: AND jtot_object_code = 'OKX_SALEPERS';
1924: Cursor l_ste_csr(p_sts_code varchar2) Is
1925: Select ste_code
1926: From okc_statuses_b
1927: WHere code = p_sts_code;
1928:
1929: Cursor l_warranty_csr(p_hdr_Id Number) Is
1930: Select lse_id

Line 3287: okc_statuses_b st,

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

Line 3817: okc_statuses_b st,

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

Line 4495: , Okc_statuses_b St

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

Line 4517: , Okc_statuses_b St

4513: ,ks.period_start
4514: From OKs_instance_k_dtls_temp temp
4515: , Okc_k_headers_all_b Kh
4516: , Okc_k_headers_all_b OKH
4517: , Okc_statuses_b St
4518: , Okc_statuses_b OSt
4519: , Okc_k_lines_b Kl
4520: , Oks_k_headers_b Ks
4521: Where Kh.Id = temp.new_contract_id

Line 4518: , Okc_statuses_b OSt

4514: From OKs_instance_k_dtls_temp temp
4515: , Okc_k_headers_all_b Kh
4516: , Okc_k_headers_all_b OKH
4517: , Okc_statuses_b St
4518: , Okc_statuses_b OSt
4519: , Okc_k_lines_b Kl
4520: , Oks_k_headers_b Ks
4521: Where Kh.Id = temp.new_contract_id
4522: And OKH.Id = temp.contract_id

Line 5912: , Okc_statuses_b St

5908: ,St.ste_code
5909: ,line.start_date
5910: From Oks_instance_k_dtls_temp temp
5911: , okc_k_lines_b line
5912: , Okc_statuses_b St
5913: Where line.id = temp.Topline_id
5914: And temp.contract_id = p_contract_id
5915: And St.code = line.sts_code;
5916:

Line 5925: , Okc_statuses_b St

5921: , St.ste_code
5922: , Kh.start_date
5923: From OKs_instance_k_dtls_temp temp
5924: , Okc_k_headers_all_b Kh
5925: , Okc_statuses_b St
5926: Where Kh.Id = temp.contract_id
5927: And St.code = Kh.sts_code;
5928: contract_id okc_datatypes.numbertabtyp;
5929: org_id okc_datatypes.numbertabtyp;

Line 6123: okc_statuses_b st,

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,
6124: okc_statuses_b Hst,
6125: oks_k_lines_b ks1,
6126: oks_k_lines_b ks2,
6127: okc_k_lines_b kl2,

Line 6124: okc_statuses_b Hst,

6120: okc_k_headers_all_b kh,
6121: oks_k_headers_b ks,
6122: okc_k_lines_b kl,
6123: okc_statuses_b st,
6124: okc_statuses_b Hst,
6125: oks_k_lines_b ks1,
6126: oks_k_lines_b ks2,
6127: okc_k_lines_b kl2,
6128: oks_instance_temp tmp,

Line 6217: okc_statuses_b st,

6213: okc_k_lines_b sl,
6214: okc_k_lines_b Tl,
6215: oks_k_lines_b okl,
6216: oks_k_lines_b okl1,
6217: okc_statuses_b st,
6218: okc_k_party_roles_b party,
6219: oks_instance_temp tmp,
6220: okc_statuses_b Hst
6221: WHERE tmp.trf = 'Y'

Line 6220: okc_statuses_b Hst

6216: oks_k_lines_b okl1,
6217: okc_statuses_b st,
6218: okc_k_party_roles_b party,
6219: oks_instance_temp tmp,
6220: okc_statuses_b Hst
6221: WHERE tmp.trf = 'Y'
6222: AND ki.object1_id1 = to_char(tmp.old_customer_product_id)
6223: AND ki.jtot_object1_code = 'OKX_CUSTPROD'
6224: AND ki.dnz_chr_id = kh.ID

Line 6293: okc_statuses_b st,

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,
6295: okc_k_lines_b tl,
6296: okc_k_party_roles_b party,
6297: Okc_statuses_b Hst,

Line 6297: Okc_statuses_b Hst,

6293: okc_statuses_b st,
6294: oks_instance_temp tmp,
6295: okc_k_lines_b tl,
6296: okc_k_party_roles_b party,
6297: Okc_statuses_b Hst,
6298: Okc_statuses_b Lst
6299: WHERE tmp.trm = 'Y'
6300: AND ki.object1_id1 = to_char(tmp.old_customer_product_id)
6301: AND ki.jtot_object1_code = 'OKX_CUSTPROD'

Line 6298: Okc_statuses_b Lst

6294: oks_instance_temp tmp,
6295: okc_k_lines_b tl,
6296: okc_k_party_roles_b party,
6297: Okc_statuses_b Hst,
6298: Okc_statuses_b Lst
6299: WHERE tmp.trm = 'Y'
6300: AND ki.object1_id1 = to_char(tmp.old_customer_product_id)
6301: AND ki.jtot_object1_code = 'OKX_CUSTPROD'
6302: AND ki.dnz_chr_id = kh.ID

Line 6358: okc_statuses_b st,

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,
6359: csi_counter_associations ctrAsc,
6360: oks_instance_temp tmp,
6361: okc_k_party_roles_b party,
6362: okc_statuses_b Hst,

Line 6362: okc_statuses_b Hst,

6358: okc_statuses_b st,
6359: csi_counter_associations ctrAsc,
6360: oks_instance_temp tmp,
6361: okc_k_party_roles_b party,
6362: okc_statuses_b Hst,
6363: okc_statuses_b Lst
6364: WHERE tmp.trm = 'Y'
6365: AND ki.object1_id1 = to_char(ctrAsc.counter_id)
6366: AND ctrAsc.source_object_id = tmp.old_customer_product_id

Line 6363: okc_statuses_b Lst

6359: csi_counter_associations ctrAsc,
6360: oks_instance_temp tmp,
6361: okc_k_party_roles_b party,
6362: okc_statuses_b Hst,
6363: okc_statuses_b Lst
6364: WHERE tmp.trm = 'Y'
6365: AND ki.object1_id1 = to_char(ctrAsc.counter_id)
6366: AND ctrAsc.source_object_id = tmp.old_customer_product_id
6367: And ctrAsc.source_object_code = 'CP'

Line 6426: okc_statuses_b st,

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,
6428: okc_k_lines_b tl,
6429: oks_k_lines_v ksl,
6430: oks_k_lines_b ks11

Line 6634: , Okc_statuses_b St

6630: Select Distinct temp.topline_id
6631: ,St.ste_code
6632: From Oks_instance_k_dtls_temp temp
6633: , okc_k_lines_b line
6634: , Okc_statuses_b St
6635: Where line.id = temp.Topline_id
6636: And temp.contract_id = p_contract_id
6637: And St.code = line.sts_code;
6638:

Line 6646: , Okc_statuses_b St

6642: , kh.inv_organization_id
6643: , St.ste_code
6644: From OKs_instance_k_dtls_temp temp
6645: , Okc_k_headers_all_b Kh
6646: , Okc_statuses_b St
6647: Where Kh.Id = temp.contract_id
6648: And St.code = Kh.sts_code;
6649:
6650: