DBA Data[Home] [Help]

APPS.OKS_MASS_UPDATE_PVT dependencies on OKS_K_LINES_V

Line 3291: oks_k_lines_v ks,

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
3295: AND temp.new_serviceline_id IS NOT NULL

Line 3821: oks_k_lines_v ks,

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
3825: AND temp.new_subline_id IS NOT NULL

Line 6446: oks_k_lines_v ksl,

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
6448: WHERE tmp.idc = 'Y'
6449: AND NVL(tmp.trm, 'N') = 'N'
6450: AND ki.object1_id1 = to_char(tmp.old_customer_product_id)

Line 6609: ,Oks_k_lines_v Ksl

6605: Cursor l_subline_invtext_csr Is
6606: Select Kl.Id
6607: ,(substr(ksl.invoice_text,1,instr(ksl.invoice_text,':',1,3))||kl.start_date||' - '|| kl.end_date)
6608: From Okc_k_lines_b Kl
6609: ,Oks_k_lines_v Ksl
6610: ,OKs_instance_k_dtls_temp temp
6611: Where kl.id = temp.subline_id
6612: And Ksl.cle_id = Kl.id;
6613:

Line 6629: ,Oks_k_lines_v Ksl

6625: Cursor l_invoice_text_csr Is
6626: Select distinct Kl.Id
6627: ,(substr(ksl.invoice_text,1,instr(ksl.invoice_text,':',1,1))||kl.start_date||' - '|| kl.end_date)
6628: From Okc_k_lines_b Kl
6629: ,Oks_k_lines_v Ksl
6630: ,OKs_instance_k_dtls_temp temp
6631: Where kl.id = temp.topline_id
6632: And Ksl.cle_id = Kl.id;
6633: