[Home] [Help]
464: ity.group_asset_yn, -- Combine Assets
465: inf.name -- invoice group
466: FROM okl_invoice_formats_v inf,
467: okl_invoice_types_v ity,
468: okl_invc_line_types_v ilt,
469: okl_invc_frmt_strms_v frs,
470: okl_strm_type_v sty
471: WHERE inf.id = ity.inf_id
472: AND ity.inf_id = p_format_id
483: ity.group_asset_yn, -- Combine Assets
484: inf.name -- invoice group
485: FROM okl_invoice_formats_v inf,
486: okl_invoice_types_v ity,
487: okl_invc_line_types_v ilt
488: WHERE inf.id = p_format_id
489: AND ity.inf_id = inf.id
490: AND ilt.ity_id = ity.id
491: AND inf.ilt_id = ilt.id;