554: NVL(vadate.attribute_applicability,G_CHNNL_ATTRIB_USE_OPTIONAL),
555: NVL(ponum.attribute_applicability,G_CHNNL_ATTRIB_USE_OPTIONAL),
556: NVL(poline.attribute_applicability,G_CHNNL_ATTRIB_USE_OPTIONAL),
557: NVL(addinfo.attribute_applicability,G_CHNNL_ATTRIB_USE_OPTIONAL)
558: FROM iby_fndcpt_pmt_chnnls_b pc, iby_pmt_mthd_attrib_appl isec,
559: iby_pmt_mthd_attrib_appl ibill, iby_pmt_mthd_attrib_appl vaflag,
560: iby_pmt_mthd_attrib_appl vacode, iby_pmt_mthd_attrib_appl vadate,
561: iby_pmt_mthd_attrib_appl ponum, iby_pmt_mthd_attrib_appl poline,
562: iby_pmt_mthd_attrib_appl addinfo
555: NVL(ponum.attribute_applicability,G_CHNNL_ATTRIB_USE_OPTIONAL),
556: NVL(poline.attribute_applicability,G_CHNNL_ATTRIB_USE_OPTIONAL),
557: NVL(addinfo.attribute_applicability,G_CHNNL_ATTRIB_USE_OPTIONAL)
558: FROM iby_fndcpt_pmt_chnnls_b pc, iby_pmt_mthd_attrib_appl isec,
559: iby_pmt_mthd_attrib_appl ibill, iby_pmt_mthd_attrib_appl vaflag,
560: iby_pmt_mthd_attrib_appl vacode, iby_pmt_mthd_attrib_appl vadate,
561: iby_pmt_mthd_attrib_appl ponum, iby_pmt_mthd_attrib_appl poline,
562: iby_pmt_mthd_attrib_appl addinfo
563: WHERE (pc.payment_channel_code = ci_pmt_channel)
556: NVL(poline.attribute_applicability,G_CHNNL_ATTRIB_USE_OPTIONAL),
557: NVL(addinfo.attribute_applicability,G_CHNNL_ATTRIB_USE_OPTIONAL)
558: FROM iby_fndcpt_pmt_chnnls_b pc, iby_pmt_mthd_attrib_appl isec,
559: iby_pmt_mthd_attrib_appl ibill, iby_pmt_mthd_attrib_appl vaflag,
560: iby_pmt_mthd_attrib_appl vacode, iby_pmt_mthd_attrib_appl vadate,
561: iby_pmt_mthd_attrib_appl ponum, iby_pmt_mthd_attrib_appl poline,
562: iby_pmt_mthd_attrib_appl addinfo
563: WHERE (pc.payment_channel_code = ci_pmt_channel)
564: -- instrument security
557: NVL(addinfo.attribute_applicability,G_CHNNL_ATTRIB_USE_OPTIONAL)
558: FROM iby_fndcpt_pmt_chnnls_b pc, iby_pmt_mthd_attrib_appl isec,
559: iby_pmt_mthd_attrib_appl ibill, iby_pmt_mthd_attrib_appl vaflag,
560: iby_pmt_mthd_attrib_appl vacode, iby_pmt_mthd_attrib_appl vadate,
561: iby_pmt_mthd_attrib_appl ponum, iby_pmt_mthd_attrib_appl poline,
562: iby_pmt_mthd_attrib_appl addinfo
563: WHERE (pc.payment_channel_code = ci_pmt_channel)
564: -- instrument security
565: AND (pc.payment_channel_code = isec.payment_method_code(+))
558: FROM iby_fndcpt_pmt_chnnls_b pc, iby_pmt_mthd_attrib_appl isec,
559: iby_pmt_mthd_attrib_appl ibill, iby_pmt_mthd_attrib_appl vaflag,
560: iby_pmt_mthd_attrib_appl vacode, iby_pmt_mthd_attrib_appl vadate,
561: iby_pmt_mthd_attrib_appl ponum, iby_pmt_mthd_attrib_appl poline,
562: iby_pmt_mthd_attrib_appl addinfo
563: WHERE (pc.payment_channel_code = ci_pmt_channel)
564: -- instrument security
565: AND (pc.payment_channel_code = isec.payment_method_code(+))
566: AND (isec.payment_flow(+) = 'FUNDS_CAPTURE')