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 1865: oks_k_headers_b ks,

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

Line 2436: -- Assigning records for okS_k_headers_b

2432: End If;
2433:
2434:
2435:
2436: -- Assigning records for okS_k_headers_b
2437: l_khrv_tbl_in (i).ID := hdr_oks_id(i); --okc_p_util.raw_to_number (SYS_GUID ());
2438: l_khrv_tbl_in (i).chr_id := hdr_id (i);
2439: l_khrv_tbl_in (i).summary_trx_yn := hdr_sum_trx (i);
2440: l_khrv_tbl_in (i).hold_billing := hdr_hold_bill (i);

Line 2924: INSERT INTO OKS_K_HEADERS_B(

2920: IF l_khrv_tbl_in.COUNT > 0
2921: THEN
2922:
2923: FORALL i IN hdr_oks_id.FIRST..hdr_oks_id.LAST
2924: INSERT INTO OKS_K_HEADERS_B(
2925: id,
2926: chr_id,
2927: acct_rule_id,
2928: tax_code,

Line 3818: oks_k_headers_b kh

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

Line 4520: , Oks_k_headers_b Ks

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

Line 5098: UPDATE oks_k_headers_b

5094: date_approved = NULL,
5095: date_signed = NULL
5096: WHERE ID = qa_contract_id ;
5097:
5098: UPDATE oks_k_headers_b
5099: SET renewal_status= 'DRAFT'
5100: WHERE CHR_ID = qa_contract_id ;
5101:
5102:

Line 5329: Update oks_k_headers_b

5325:
5326:
5327: End Loop; -- Contracts
5328: Forall k in contract_id.first..contract_id.last
5329: Update oks_k_headers_b
5330: Set tax_amount = (select Nvl(sum(ks.tax_amount),0) from oks_k_lines_b ks, okc_k_lines_b kl
5331: where kl.dnz_chr_id = contract_id(k) and ks.cle_id = kl.id and kl.lse_id in (9,25))
5332: Where chr_id = contract_id(k);
5333:

Line 6121: oks_k_headers_b ks,

6117: ,OKS_IB_UTIL_PVT.get_credit_option(party.object1_id1,kh.authoring_org_id,tmp.transaction_date)),
6118: Kh.inv_organization_id
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,

Line 6212: oks_k_headers_b ks,

6208: Kh.inv_organization_id
6209:
6210: FROM okc_k_items ki,
6211: okc_k_headers_all_b kh,
6212: oks_k_headers_b ks,
6213: okc_k_lines_b sl,
6214: okc_k_lines_b Tl,
6215: oks_k_lines_b okl,
6216: oks_k_lines_b okl1,