Product: | IBY - Payments |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IBY_PAYMENT_PROFILES |
SELECT S.SYSTEM_PROFILE_CODE
, S.SYSTEM_PROFILE_NAME
, S.SYSTEM_PROFILE_DESCRIPTION
, S.BEPID
, S.SECURITY_PROTOCOL_CODE
, S.TRANSMIT_PROTOCOL_CODE
, S.PAYMENT_FORMAT_CODE
, S.POSITIVE_PAY_FORMAT_CODE
, S.PAY_FILE_LETTER_FORMAT_CODE
, S.PRINT_INSTRUCTION_IMMED_FLAG
, S.TRANSMIT_INSTR_IMMED_FLAG
, S.DEFAULT_PRINTER
, S.DEFAULT_PAYMENT_DOCUMENT_ID
, S.PERIODIC_SEQUENCE_NAME_1
, S.PERIODIC_SEQUENCE_NAME_2
, S.PERIODIC_SEQUENCE_NAME_3
, S.PROCESSING_TYPE
, S.MARK_COMPLETE_EVENT
, S.MANUAL_MARK_COMPLETE_FLAG
, S.POSITIVE_PAY_DELIVERY_FLAG
, S.CREATED_BY
, S.CREATION_DATE
, S.LAST_UPDATED_BY
, S.LAST_UPDATE_DATE
, S.LAST_UPDATE_LOGIN
, S.OBJECT_VERSION_NUMBER
, S.DECLARATION_OPTION
, S.DCL_ONLY_FOREIGN_CURR_PMT_FLAG
, S.DECLARATION_REPORT_FORMAT_CODE
, S.DECLARATION_CURR_FX_RATE_TYPE
, S.DECLARATION_CURRENCY_CODE
, S.DECLARATION_THRESHOLD_AMOUNT
, S.BANK_INSTRUCTION1_CODE
, S.BANK_INSTRUCTION2_CODE
, S.BANK_INSTRUCTION_DETAILS
, S.PAYMENT_TEXT_MESSAGE1
, S.PAYMENT_TEXT_MESSAGE2
, DECODE(S.INACTIVE_DATE
, NULL
, A.INACTIVE_DATE
, (DECODE(A.INACTIVE_DATE
, NULL
, S.INACTIVE_DATE
, DECODE(SIGN(S.INACTIVE_DATE-A.INACTIVE_DATE)
, 1
, A.INACTIVE_DATE
, S.INACTIVE_DATE ))))
, S.ACK_TRANSMIT_PROTOCOL_CODE
, S.ACK_SECURITY_PROTOCOL_CODE
, S.SEEDED_FLAG
, S.SEND_TO_FILE_FLAG
, S.ATTRIBUTE_CATEGORY
, S.ATTRIBUTE1
, S.ATTRIBUTE2
, S.ATTRIBUTE3
, S.ATTRIBUTE4
, S.ATTRIBUTE5
, S.ATTRIBUTE6
, S.ATTRIBUTE7
, S.ATTRIBUTE8
, S.ATTRIBUTE9
, S.ATTRIBUTE10
, S.ATTRIBUTE11
, S.ATTRIBUTE12
, S.ATTRIBUTE13
, S.ATTRIBUTE14
, S.ATTRIBUTE15
, A.PAYMENT_PROFILE_ID
, A.PAYMENT_PROFILE_NAME
, A.BEP_ACCOUNT_ID
, A.SECURITY_CONFIGURATION_ID
, A.TRANSMIT_CONFIGURATION_ID
, A.RESET_VALUE_1
, A.LAST_USED_NUMBER_1
, A.RESET_REQUEST_1
, A.RESET_VALUE_2
, A.LAST_USED_NUMBER_2
, A.RESET_REQUEST_2
, A.RESET_VALUE_3
, A.LAST_USED_NUMBER_3
, A.RESET_REQUEST_3
, A.ACK_SEC_CONFIG_ID
, A.ACK_TRANSMIT_CONFIG_ID
FROM IBY_SYS_PMT_PROFILES_VL S
, IBY_ACCT_PMT_PROFILES_VL A
WHERE S.SYSTEM_PROFILE_CODE = A.SYSTEM_PROFILE_CODE(+)