DBA Data[Home] [Help]

APPS.OKL_INTERNAL_TO_EXTERNAL dependencies on OKL_INVOICE_FORMATS_V

Line 899: okl_invoice_formats_v inf

895: SELECT inf.id,
896: rul.rule_information4 review_invoice_yn
897: FROM okc_rule_groups_v rgp,
898: okc_rules_v rul,
899: okl_invoice_formats_v inf
900: WHERE rgp.dnz_chr_id = cp_khr_id
901: AND rgp.chr_id = rgp.dnz_chr_id
902: AND rgp.id = rul.rgp_id
903: AND rgp.cle_id IS NULL

Line 908: l_inf_id okl_invoice_formats_v.id%TYPE;

904: AND rgp.rgd_code = 'LABILL'
905: AND rul.rule_information_category = 'LAINVD'
906: AND rul.rule_information1 = inf.name;
907:
908: l_inf_id okl_invoice_formats_v.id%TYPE;
909:
910: -- -------------------------------------------
911: -- To support private label transfers to
912: -- AR. Bug 4525643