AP Payment Documents

-- ##############################################################################
--      PAYMENT DOCUMENTS
-- ##############################################################################
   
         select payment_document_name
              , payment_document_id
              , payment_instruction_id
              , internal_bank_account_id
              , cba.bank_account_name
              , cba.bank_account_num
              , cba.currency_code
	          , paper_stock_type
              , attached_remittance_stub_flag
              , number_of_lines_per_remit_stub
              , number_of_setup_documents
	          , ce_payment_documents.format_code
              , first_available_document_num
              , last_available_document_number
              , last_issued_document_number
              , manual_payments_only_flag
              , ce_payment_documents.attribute_category
              , inactive_date
              , decode(inactive_date, 'Y', 'N') status
	          , meaning paper_stock_type_meaning
	          , fmts.format_name 
	       from ce_payment_documents
	          , ce_lookups lookup
	          , iby_formats_vl fmts
              , ce_bank_accounts cba
          where lookup_type = 'CE_PAPER_STOCK_TYPES' 
	        and paper_stock_type = lookup.lookup_code 
	        and ce_payment_documents.format_code=fmts.format_code
            and internal_bank_account_id = cba.bank_account_id;

Leave a Comment

Your email address will not be published. Required fields are marked *

*
*