APPS.OKI_DBI_LOAD_CLEB_PVT dependencies on OKC_K_HEADERS_ALL_B

Line 632: FROM okc_k_headers_all_b h

628: 'DNR', 'DNR',
629: 'NSR', decode(h.approval_type, 'Y', 'NSR', 'N', 'NSR', 'NSR')
630: ) subsequent_renewal_type_code /* Added this colunm as a part of ER#5760744 */
631: ,h.term_cancel_source hdr_term_cancel_source /* Added for ER 6684955 */
632: FROM okc_k_headers_all_b h
633: , okc_k_vers_numbers v
634: WHERE 1=1
635: AND
636: (

Line 903: , okc_k_headers_all_b h

899: 'NSR', decode(h.approval_type, 'Y', 'NSR', 'N', 'NSR', 'NSR')
900: ) subsequent_renewal_type_code /* Added this colunm as a part of ER#5760744 */
901: ,h.term_cancel_source hdr_term_cancel_source /* for ER6684955 */
902: FROM oki_dbi_chr_stage_inc inc
903: , okc_k_headers_all_b h
904: , okc_operation_lines ren_rel
905: , oki_dbi_chr_stage_inc inc2
906: , okc_operation_instances opins
907: WHERE 1=1

Line 994: , okc_k_headers_all_b h

990: g_0001_date
991: END)
992: END ASC , srep.last_update_date DESC, srep.id ASC) sales_group_id
993: FROM okc_contacts srep
994: , okc_k_headers_all_b h
995: WHERE 1 = 1
996: AND h.id = srep.dnz_chr_id
997: AND srep.cro_code = l_salesperson_code
998: AND NVL (srep.primary_yn, 'Y') = 'Y'

Line 1227: FROM okc_k_headers_all_b h

1223: 'DNR', 'DNR',
1224: 'NSR', decode(h.approval_type, 'Y', 'NSR', 'N', 'NSR', 'NSR')
1225: ) subsequent_renewal_type_code /* for ER#5760744 */
1226: , h.term_cancel_source hdr_term_cancel_source /* for ER 6684955 */
1227: FROM okc_k_headers_all_b h
1228: , okc_k_vers_numbers v
1229: WHERE 1=1
1230: AND v.last_update_date >= l_start_date
1231: AND v.last_update_date+0 <= l_end_date

Line 1636: okc_k_headers_all_b h

1632: , h.term_cancel_source hdr_term_cancel_source /* Added for ER 6684955 */
1633: FROM oki_dbi_chr_stage_inc inc ,
1634: okc_operation_lines ren_rel ,
1635: okc_operation_instances opins,
1636: okc_k_headers_all_b h
1637: WHERE 1=1
1638: AND ren_rel.object_chr_id = h.id
1639: AND ren_rel.subject_chr_id = inc.id
1640: AND ren_rel.subject_cle_id IS NULL

Line 1938: , okc_k_headers_all_b h

1934: , inc.to_currency AS func_currency
1935: , decode(inc.rate_g, -3, g_euro_start_date, inc.curr_conv_date) conversion_date
1936: FROM oki_dbi_curr_conv inc
1937: , oki_dbi_chr_inc chr
1938: , okc_k_headers_all_b h
1939: WHERE 1 = 1
1940: --AND inc.rate_type <> 'USER'
1941: AND inc.rate_g < 0
1942: AND inc.rate_g NOT IN (-2,-3,-5)

Line 1983: , okc_k_headers_all_b h

1979: , inc.to_currency AS func_currency
1980: , decode(inc.rate_sg,-3,g_euro_start_date,inc.curr_conv_date) AS CONVERSION_DATE
1981: FROM oki_dbi_curr_conv inc
1982: , oki_dbi_chr_inc chr
1983: , okc_k_headers_all_b h
1984: WHERE inc.rate_sg < 0
1985: AND inc.rate_sg NOT IN (-2,-3,-5)
1986: --AND inc.rate_type <> 'USER'
1987: AND decode(upper(inc.rate_type),'USER',inc.chr_id,chr.chr_id) = chr.chr_id

Line 2030: , okc_k_headers_all_b h

2026: , inc.to_currency AS func_currency
2027: , decode(inc.rate_f,-3,g_euro_start_date,inc.curr_conv_date) AS conversion_date
2028: FROM oki_dbi_curr_conv inc
2029: , oki_dbi_chr_inc chr
2030: , okc_k_headers_all_b h
2031: WHERE 1 = 1
2032: --AND inc.rate_type <> 'USER'
2033: AND decode(upper(inc.rate_type),'USER',inc.chr_id,chr.chr_id) = chr.chr_id
2034: AND (inc.rate_f <= 0 OR inc.rate_f is null)

Line 2075: , okc_k_headers_all_b h

2071: , inc.curr_conv_date AS conversion_date
2072: , inc.rate_sg func_sglobal_rate
2073: FROM oki_dbi_curr_conv inc
2074: , oki_dbi_chr_inc chr
2075: , okc_k_headers_all_b h
2076: WHERE inc.rate_sg < 0
2077: --AND inc.rate_type <> 'USER'
2078: AND decode(upper(inc.rate_type),'USER',inc.chr_id,chr.chr_id) = chr.chr_id
2079: AND h.id = chr.chr_id