View: IBY_SYS_PMT_PROFILES_VL

Product:	IBY - Payments
Description:
Implementation/DBA Data:	APPS.IBY_SYS_PMT_PROFILES_VL

View Text

SELECT B.ROWID
, B.SYSTEM_PROFILE_CODE
, T.SYSTEM_PROFILE_NAME
, T.SYSTEM_PROFILE_DESCRIPTION
, B.BEPID
, B.SECURITY_PROTOCOL_CODE
, B.TRANSMIT_PROTOCOL_CODE
, B.PAYMENT_FORMAT_CODE
, B.POSITIVE_PAY_FORMAT_CODE
, B.PAY_FILE_LETTER_FORMAT_CODE
, B.PRINT_INSTRUCTION_IMMED_FLAG
, B.TRANSMIT_INSTR_IMMED_FLAG
, B.DEFAULT_PRINTER
, B.DEFAULT_PAYMENT_DOCUMENT_ID
, B.PERIODIC_SEQUENCE_NAME_1
, B.PERIODIC_SEQUENCE_NAME_2
, B.PERIODIC_SEQUENCE_NAME_3
, B.PROCESSING_TYPE
, B.MARK_COMPLETE_EVENT
, B.MANUAL_MARK_COMPLETE_FLAG
, B.POSITIVE_PAY_DELIVERY_FLAG
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER
, B.DECLARATION_OPTION
, B.DCL_ONLY_FOREIGN_CURR_PMT_FLAG
, B.DECLARATION_REPORT_FORMAT_CODE
, B.DECLARATION_CURR_FX_RATE_TYPE
, B.DECLARATION_CURRENCY_CODE
, B.DECLARATION_THRESHOLD_AMOUNT
, B.BANK_INSTRUCTION1_CODE
, B.BANK_INSTRUCTION2_CODE
, B.BANK_INSTRUCTION_DETAILS
, B.PAYMENT_TEXT_MESSAGE1
, B.PAYMENT_TEXT_MESSAGE2
, B.INACTIVE_DATE
, B.ACK_TRANSMIT_PROTOCOL_CODE
, B.ACK_SECURITY_PROTOCOL_CODE
, B.SEEDED_FLAG
, B.SEND_TO_FILE_FLAG
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.PI_REGISTER_FORMAT
, B.AUTOMATIC_PI_REG_SUBMIT
FROM IBY_SYS_PMT_PROFILES_TL T
, IBY_SYS_PMT_PROFILES_B B
WHERE B.SYSTEM_PROFILE_CODE = T.SYSTEM_PROFILE_CODE
AND T.LANGUAGE = USERENV('LANG')

Columns