APPS.OKS_MASS_UPDATE_PVT dependencies on OKS_K_HEADERS_B

Line 71: --| OKS_K_HEADERS_B | X | X | | | | |

67: --| OKC_CPL_PVT | | | | | |X |
68: --+---------------------------------+---+---+---+---+---+----------------------+
69: --| OKX_CUST_SITE_USES_V | X | | | | | |
70: --+---------------------------------+---+---+---+---+---+----------------------+
71: --| OKS_K_HEADERS_B | X | X | | | | |
72: --+---------------------------------+---+---+---+---+---+----------------------+
73: --| OKC_K_ACCESSES | | X | | | | |
74: --+---------------------------------+---+---+---+---+---+----------------------+
75: --| OKS_K_SALES_CREDITS | | X | | | | |

Line 1869: oks_k_headers_b ks,

1865: FROM okc_k_headers_all_b where id = contract_id ) oks_id,
1866: ks.price_uom
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

Line 2441: -- Assigning records for okS_k_headers_b

2437: End If;
2438:
2439:
2440:
2441: -- Assigning records for okS_k_headers_b
2442: l_khrv_tbl_in (i).ID := hdr_oks_id(i); --okc_p_util.raw_to_number (SYS_GUID ());
2443: l_khrv_tbl_in (i).chr_id := hdr_id (i);
2444: l_khrv_tbl_in (i).summary_trx_yn := hdr_sum_trx (i);
2445: l_khrv_tbl_in (i).hold_billing := hdr_hold_bill (i);

Line 2929: INSERT INTO OKS_K_HEADERS_B(

2925: IF l_khrv_tbl_in.COUNT > 0
2926: THEN
2927:
2928: FORALL i IN hdr_oks_id.FIRST..hdr_oks_id.LAST
2929: INSERT INTO OKS_K_HEADERS_B(
2930: id,
2931: chr_id,
2932: acct_rule_id,
2933: tax_code,

Line 3823: oks_k_headers_b kh

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
3827: AND itm.jtot_object1_code IN ('OKX_CUSTPROD')

Line 4525: , Oks_k_headers_b Ks

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
4528: And Ks.chr_id = Kh.id
4529: And St.code = Kh.sts_code

Line 5113: UPDATE oks_k_headers_b

5109: RAISE g_exception_halt_validation;
5110: END IF;
5111:
5112:
5113: UPDATE oks_k_headers_b
5114: SET renewal_status= 'DRAFT'
5115: WHERE CHR_ID = qa_contract_id ;
5116:
5117:

Line 5346: Update oks_k_headers_b

5342: End Loop; -- Contracts
5343: END IF; --Added for Bug#14183916
5344: IF Contract_id.count > 0 THEN --Added for Bug#14183916
5345: Forall k in contract_id.first..contract_id.last
5346: Update oks_k_headers_b
5347: Set tax_amount = (select Nvl(sum(ks.tax_amount),0) from oks_k_lines_b ks, okc_k_lines_b kl
5348: where kl.dnz_chr_id = contract_id(k) and ks.cle_id = kl.id and kl.lse_id in (9,25))
5349: Where chr_id = contract_id(k);
5350: END IF; --Added for Bug#14183916

Line 6138: oks_k_headers_b ks,

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,
6141: okc_statuses_b Hst,
6142: oks_k_lines_b ks1,

Line 6229: oks_k_headers_b ks,

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,
6232: oks_k_lines_b okl,
6233: oks_k_lines_b okl1,