[Home] [Help]
382: SELECT inf.id,
383: rul.rule_information4 review_invoice_yn
384: FROM okc_rule_groups_v rgp,
385: okc_rules_v rul,
386: okl_invoice_formats_v inf
387: WHERE rgp.dnz_chr_id = cp_khr_id
388: AND rgp.chr_id = rgp.dnz_chr_id
389: AND rgp.id = rul.rgp_id
390: AND rgp.cle_id IS NULL
391: AND rgp.rgd_code = 'LABILL'
392: AND rul.rule_information_category = 'LAINVD'
393: AND rul.rule_information1 = inf.name;
394:
395: l_inf_id okl_invoice_formats_v.id%TYPE;
396:
397: -- -------------------------------------------
398: -- To support private label transfers to
399: -- AR. Bug 4525643