Oracle EBS accounts payable payment query
SELECT SYSTEM_PROFILE_CODE,
BEPID,
SECURITY_PROTOCOL_CODE,
TRANSMIT_PROTOCOL_CODE,
PAYMENT_FORMAT_CODE,
POSITIVE_PAY_FORMAT_CODE,
PAY_FILE_LETTER_FORMAT_CODE,
PRINT_INSTRUCTION_IMMED_FLAG,
DEFAULT_PRINTER,
DEFAULT_PAYMENT_DOCUMENT_ID,
PERIODIC_SEQUENCE_NAME_1,
PERIODIC_SEQUENCE_NAME_2,
PERIODIC_SEQUENCE_NAME_3,
PROCESSING_TYPE,
LOGICAL_GROUPING_MODE,
BATCH_BOOKING_FLAG,
MARK_COMPLETE_EVENT,
MANUAL_MARK_COMPLETE_FLAG,
POSITIVE_PAY_DELIVERY_FLAG,
TRANSMIT_INSTR_IMMED_FLAG,
SEEDED_FLAG,
AUTOMATIC_PI_REG_SUBMIT,
DECLARATION_OPTION,
DCL_ONLY_FOREIGN_CURR_PMT_FLAG,
DECLARATION_REPORT_FORMAT_CODE,
DECLARATION_CURR_FX_RATE_TYPE,
DECLARATION_THRESHOLD_AMOUNT,
BANK_INSTRUCTION1_CODE,
BANK_INSTRUCTION2_CODE,
BANK_INSTRUCTION_DETAILS,
PAYMENT_TEXT_MESSAGE1,
PAYMENT_TEXT_MESSAGE2,
INACTIVE_DATE,
ACK_TRANSMIT_PROTOCOL_CODE,
ACK_SECURITY_PROTOCOL_CODE,
SEND_TO_FILE_FLAG,
PI_REGISTER_FORMAT,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
OUTBOUND_PMT_FILE_DIRECTORY,
OUTBOUND_PMT_FILE_EXTENSION,
OUTBOUND_PMT_FILE_PREFIX,
POSITIVE_PAY_FILE_DIRECTORY,
POSITIVE_PAY_FILE_EXTENSION,
POSITIVE_PAY_FILE_PREFIX,
ELECTRONIC_PROCESSING_CHANNEL,
DISALLOW_SAVE_PRINT_FLAG,
DECLARATION_CURRENCY_CODE#1,
SERVICE_LEVEL_CODE,
DELIVERY_CHANNEL_CODE
FROM iby.IBY_SYS_PMT_PROFILES_B
WHERE NVL (inactive_date, SYSDATE) >= SYSDATE
ORDER BY system_profile_code;
Payment Templates
————————
SELECT TEMPLATE_NAME,
TEMPLATE_TYPE,
DESCRIPTION,
INACTIVE_DATE,
ADDL_PAY_FROM_DAYS,
ADDL_PAY_THRU_DAYS,
HI_PAYMENT_PRIORITY,
LOW_PAYMENT_PRIORITY,
PAY_ONLY_WHEN_DUE_FLAG,
ZERO_INV_ALLOWED_FLAG,
VENDOR_TYPE_LOOKUP_CODE,
PAYMENT_METHOD_CODE,
INV_EXCHANGE_RATE_TYPE,
PAY_GROUP_OPTION,
CURRENCY_GROUP_OPTION,
LE_GROUP_OPTION,
OU_GROUP_OPTION,
PAYMENT_DATE_OPTION,
ADDL_PAYMENT_DAYS,
BANK_CHARGE_BEARER,
SETTLEMENT_PRIORITY,
FIRST_VOUCHER_NUMBER,
TRANSFER_PRIORITY,
PAYMENT_EXCHANGE_RATE_TYPE,
ZERO_AMOUNTS_ALLOWED,
PAYABLES_REVIEW_SETTINGS,
CALC_AWT_INT_FLAG,
PAYMENTS_REVIEW_SETTINGS,
CREATE_INSTRS_FLAG,
DOCUMENT_REJECTION_LEVEL_CODE,
PAYMENT_REJECTION_LEVEL_CODE,
RESUBMIT_FLAG,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15
FROM ap.AP_PAYMENT_TEMPLATES
WHERE NVL (inactive_date, SYSDATE) >= SYSDATE
ORDER BY template_name, template_type;
Payment Documents
————————-
SELECT PAYMENT_DOC_CATEGORY,
PAYMENT_DOCUMENT_NAME,
PAPER_STOCK_TYPE,
ATTACHED_REMITTANCE_STUB_FLAG,
NUMBER_OF_LINES_PER_REMIT_STUB,
NUMBER_OF_SETUP_DOCUMENTS,
FORMAT_CODE,
FIRST_AVAILABLE_DOCUMENT_NUM,
LAST_AVAILABLE_DOCUMENT_NUMBER,
MANUAL_PAYMENTS_ONLY_FLAG,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
INACTIVE_DATE
FROM ce.ce_payment_documents
WHERE NVL (inactive_date, SYSDATE) >= SYSDATE
ORDER BY payment_doc_category,
payment_document_name,
format_code,
paper_stock_type,
first_available_document_num;