APPS.OKS_EXTWARPRGM_PVT dependencies on OKS_K_HEADERS_B

Line 1142: FROM okc_k_headers_all_b a, oks_k_headers_b b, okc_statuses_b c

1138: a.conversion_euro_rate, b.inv_trx_type, b.ar_interface_yn,
1139: b.summary_trx_yn, b.hold_billing, a.inv_organization_id,
1140: a.scs_code, c.ste_code source_ste_code, b.period_start,
1141: b.period_type, b.price_uom, a.billed_at_source
1142: FROM okc_k_headers_all_b a, oks_k_headers_b b, okc_statuses_b c
1143: WHERE a.ID = l_chr_id AND a.ID = b.chr_id AND p_sts_code = c.code;
1144:
1145: -- and c.ste_code in ('ACTIVE','ENTERED','SIGNED');
1146:

Line 1174: FROM okc_k_headers_all_b a, oks_k_headers_b b, okc_statuses_b c

1170: l_billed_at_source VARCHAR2
1171: )
1172: IS
1173: SELECT a.ID
1174: FROM okc_k_headers_all_b a, oks_k_headers_b b, okc_statuses_b c
1175: WHERE a.ID = l_target_chr_id
1176: AND a.ID = b.chr_id
1177: AND a.sts_code= c.code --Bug fix 5614310
1178: AND c.ste_code IN ('ACTIVE', 'ENTERED', 'SIGNED')

Line 8421: UPDATE oks_k_headers_b

8417: SET tax_amount = tax_amount + l_newtax
8418: WHERE cle_id = l_lineid;
8419:
8420: -- Update header tax amount
8421: UPDATE oks_k_headers_b
8422: SET tax_amount = tax_amount + l_newtax
8423: WHERE chr_id = p_kdtl_tbl (l_ctr).hdr_id;
8424: END IF;
8425:

Line 9519: FROM okc_k_headers_b Kh, oks_k_headers_b Ks

9515:
9516: CURSOR l_Launch_WF_csr (p_hdr_id NUMBER)
9517: IS
9518: SELECT 'Y'
9519: FROM okc_k_headers_b Kh, oks_k_headers_b Ks
9520: , okc_statuses_b sts
9521: WHERE Kh.ID = p_hdr_id
9522: And Ks.chr_id = Kh.id
9523: And kh.sts_code = sts.code

Line 12684: UPDATE oks_k_headers_b

12680: l_merge_chr_id
12681: AND lse_id IN (1, 19))
12682: WHERE ID = l_merge_chr_id;
12683:
12684: UPDATE oks_k_headers_b
12685: SET tax_amount =
12686: NVL (tax_amount, 0)
12687: + NVL ((SELECT tax_amount
12688: FROM oks_k_lines_b

Line 13231: UPDATE oks_k_headers_b

13227: l_merge_chr_id
13228: AND lse_id IN (1, 19))
13229: WHERE ID = l_merge_chr_id;
13230:
13231: UPDATE oks_k_headers_b
13232: SET tax_amount =
13233: NVL (tax_amount, 0)
13234: + NVL ((SELECT tax_amount
13235: FROM oks_k_lines_b

Line 13727: UPDATE oks_k_headers_b

13723: WHERE dnz_chr_id = l_chr_id
13724: AND lse_id IN (1, 19))
13725: WHERE ID = l_chr_id;
13726:
13727: UPDATE oks_k_headers_b
13728: SET tax_amount =
13729: NVL (tax_amount, 0)
13730: + NVL ((SELECT tax_amount
13731: FROM oks_k_lines_b

Line 16148: UPDATE oks_k_headers_b

16144: AND date_cancelled IS NULL )
16145: WHERE ID = p_kdtl_tbl (l_ctr).hdr_id;
16146:
16147:
16148: UPDATE oks_k_headers_b
16149: SET tax_amount = ( SELECT (NVL (SUM (NVL(tax_amount,0)),0))
16150: FROM oks_k_lines_b
16151: WHERE cle_id IN (SELECT id
16152: FROM okc_k_lineS_b

Line 16627: UPDATE oks_k_headers_b

16623: AND lse_id IN (1, 19)
16624: AND date_cancelled IS NULL)
16625: WHERE ID = p_kdtl_tbl (l_ctr).hdr_id;
16626:
16627: UPDATE oks_k_headers_b
16628: SET tax_amount = ( SELECT (NVL (SUM (NVL(tax_amount,0)),0))
16629: FROM oks_k_lines_b
16630: WHERE cle_id IN (SELECT id
16631: FROM okc_k_lineS_b

Line 16841: UPDATE oks_k_headers_b

16837: AND date_cancelled IS NULL)
16838: WHERE ID = p_kdtl_tbl (l_ctr).hdr_id;
16839:
16840:
16841: UPDATE oks_k_headers_b
16842: SET tax_amount = ( SELECT (NVL (SUM (NVL(tax_amount,0)),0))
16843: FROM oks_k_lines_b
16844: WHERE cle_id IN (SELECT id
16845: FROM okc_k_lineS_b