DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.IBY_PAYMENT_PROFILES

Object Details
Object Name: IBY_PAYMENT_PROFILES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIBY.IBY_PAYMENT_PROFILES
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
SYSTEM_PROFILE_CODE VARCHAR2 (100) Yes
SYSTEM_PROFILE_NAME VARCHAR2 (100) Yes
SYSTEM_PROFILE_DESCRIPTION VARCHAR2 (255)
BEPID NUMBER (15)
SECURITY_PROTOCOL_CODE VARCHAR2 (100)
TRANSMIT_PROTOCOL_CODE VARCHAR2 (100)
PAYMENT_FORMAT_CODE VARCHAR2 (30) Yes
POSITIVE_PAY_FORMAT_CODE VARCHAR2 (30)
PAY_FILE_LETTER_FORMAT_CODE VARCHAR2 (30)
PRINT_INSTRUCTION_IMMED_FLAG VARCHAR2 (1) Yes
TRANSMIT_INSTR_IMMED_FLAG VARCHAR2 (1) Yes
DEFAULT_PRINTER VARCHAR2 (255)
DEFAULT_PAYMENT_DOCUMENT_ID NUMBER (15)
PERIODIC_SEQUENCE_NAME_1 VARCHAR2 (80)
PERIODIC_SEQUENCE_NAME_2 VARCHAR2 (80)
PERIODIC_SEQUENCE_NAME_3 VARCHAR2 (80)
PROCESSING_TYPE VARCHAR2 (30) Yes
MARK_COMPLETE_EVENT VARCHAR2 (30) Yes
MANUAL_MARK_COMPLETE_FLAG VARCHAR2 (1) Yes
LOGICAL_GROUPING_MODE VARCHAR2 (50)
Specifies the grouping mode of the payment process profile.
BATCH_BOOKING_FLAG VARCHAR2 (1)
Specifies whether bank will send statement based on payment/group
POSITIVE_PAY_DELIVERY_FLAG VARCHAR2 (1) Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (15) Yes
DECLARATION_OPTION VARCHAR2 (30)
DCL_ONLY_FOREIGN_CURR_PMT_FLAG VARCHAR2 (1)
DECLARATION_REPORT_NAME VARCHAR2 (30)
DECLARATION_CURR_FX_RATE_TYPE VARCHAR2 (255)
DECLARATION_CURRENCY_CODE VARCHAR2 (10)
DECLARATION_THRESHOLD_AMOUNT NUMBER

BANK_INSTRUCTION1_CODE VARCHAR2 (30)
BANK_INSTRUCTION2_CODE VARCHAR2 (30)
BANK_INSTRUCTION_DETAILS VARCHAR2 (255)
PAYMENT_TEXT_MESSAGE1 VARCHAR2 (150)
PAYMENT_TEXT_MESSAGE2 VARCHAR2 (150)
INACTIVE_DATE DATE

ACK_TRANSMIT_PROTOCOL_CODE VARCHAR2 (100)
ACK_SECURITY_PROTOCOL_CODE VARCHAR2 (100)
SEEDED_FLAG VARCHAR2 (1)
SEND_TO_FILE_FLAG VARCHAR2 (1) Yes
ATTRIBUTE_CATEGORY VARCHAR2 (150)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
PAYMENT_PROFILE_ID NUMBER (15)
PAYMENT_PROFILE_NAME VARCHAR2 (100)
BEP_ACCOUNT_ID NUMBER (15)
SECURITY_CONFIGURATION_ID NUMBER (15)
TRANSMIT_CONFIGURATION_ID NUMBER (15)
RESET_VALUE_1 NUMBER (15)
LAST_USED_NUMBER_1 NUMBER (15)
RESET_REQUEST_1 NUMBER (15)
RESET_VALUE_2 NUMBER (15)
LAST_USED_NUMBER_2 NUMBER (15)
RESET_REQUEST_2 NUMBER (15)
RESET_VALUE_3 NUMBER (15)
LAST_USED_NUMBER_3 NUMBER (15)
RESET_REQUEST_3 NUMBER (15)
ACK_SEC_CONFIG_ID NUMBER (15)
ACK_TRANSMIT_CONFIG_ID NUMBER (15)
OUTBOUND_PMT_FILE_DIRECTORY VARCHAR2 (255)
File directory where output of outbound payment file should be stored.
OUTBOUND_PMT_FILE_EXTENSION VARCHAR2 (255)
File extension of outbound payment files.
OUTBOUND_PMT_FILE_PREFIX VARCHAR2 (255)
File name prefix of outbound payment files.
POSITIVE_PAY_FILE_DIRECTORY VARCHAR2 (255)
File directory where output of positive pay file should be stored.
POSITIVE_PAY_FILE_EXTENSION VARCHAR2 (255)
File extension of positive pay files.
POSITIVE_PAY_FILE_PREFIX VARCHAR2 (255)
File name prefix of positive pay files.
ELECTRONIC_PROCESSING_CHANNEL VARCHAR2 (50)
DISALLOW_SAVE_PRINT_FLAG VARCHAR2 (1)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SYSTEM_PROFILE_CODE
,      SYSTEM_PROFILE_NAME
,      SYSTEM_PROFILE_DESCRIPTION
,      BEPID
,      SECURITY_PROTOCOL_CODE
,      TRANSMIT_PROTOCOL_CODE
,      PAYMENT_FORMAT_CODE
,      POSITIVE_PAY_FORMAT_CODE
,      PAY_FILE_LETTER_FORMAT_CODE
,      PRINT_INSTRUCTION_IMMED_FLAG
,      TRANSMIT_INSTR_IMMED_FLAG
,      DEFAULT_PRINTER
,      DEFAULT_PAYMENT_DOCUMENT_ID
,      PERIODIC_SEQUENCE_NAME_1
,      PERIODIC_SEQUENCE_NAME_2
,      PERIODIC_SEQUENCE_NAME_3
,      PROCESSING_TYPE
,      MARK_COMPLETE_EVENT
,      MANUAL_MARK_COMPLETE_FLAG
,      LOGICAL_GROUPING_MODE
,      BATCH_BOOKING_FLAG
,      POSITIVE_PAY_DELIVERY_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      DECLARATION_OPTION
,      DCL_ONLY_FOREIGN_CURR_PMT_FLAG
,      DECLARATION_REPORT_NAME
,      DECLARATION_CURR_FX_RATE_TYPE
,      DECLARATION_CURRENCY_CODE
,      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
,      SEEDED_FLAG
,      SEND_TO_FILE_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PAYMENT_PROFILE_ID
,      PAYMENT_PROFILE_NAME
,      BEP_ACCOUNT_ID
,      SECURITY_CONFIGURATION_ID
,      TRANSMIT_CONFIGURATION_ID
,      RESET_VALUE_1
,      LAST_USED_NUMBER_1
,      RESET_REQUEST_1
,      RESET_VALUE_2
,      LAST_USED_NUMBER_2
,      RESET_REQUEST_2
,      RESET_VALUE_3
,      LAST_USED_NUMBER_3
,      RESET_REQUEST_3
,      ACK_SEC_CONFIG_ID
,      ACK_TRANSMIT_CONFIG_ID
,      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
FROM APPS.IBY_PAYMENT_PROFILES;

Dependencies

[top of page]

APPS.IBY_PAYMENT_PROFILES references the following:

SchemaAPPS
ViewIBY_ACCT_PMT_PROFILES_VL
ViewIBY_SYS_PMT_PROFILES_VL
APPS.IBY_PAYMENT_PROFILES is referenced by following:

SchemaAPPS
ViewAP_CHECKS_V
ViewAP_PAYMENT_EXTRACT_HEADER_V
Package BodyAP_PAY_SINGLE_INVOICE_PKG - show dependent code
Package BodyAP_PMT_CALLOUT_PKG - show dependent code
TriggerAP_SSE_NOTIFY_EMPLOYEE
Package BodyIBY_ASSIGN_PUB - show dependent code
Package BodyIBY_BUILD_INSTRUCTIONS_PUB_PKG - show dependent code
PL/SQL PackageIBY_BUILD_UTILS_PKG - show dependent code
Package BodyIBY_BUILD_UTILS_PKG - show dependent code
Package BodyIBY_CHECKNUMBER_PUB - show dependent code
PL/SQL PackageIBY_DISBURSEMENT_COMP_PUB - show dependent code
Package BodyIBY_DISBURSEMENT_COMP_PUB - show dependent code
Package BodyIBY_DISBURSE_SINGLE_PMT_PKG - show dependent code
PL/SQL PackageIBY_DISBURSE_SINGLE_PMT_PKG - show dependent code
PL/SQL PackageIBY_DISBURSE_SUBMIT_PUB_PKG - show dependent code
Package BodyIBY_DISBURSE_SUBMIT_PUB_PKG - show dependent code
Package BodyIBY_DISBURSE_UI_API_PUB_PKG - show dependent code
ViewIBY_EXT_FD_INS_1_0_V
Package BodyIBY_FD_EXTRACT_GEN_PVT - show dependent code
Package BodyIBY_FD_POST_PICP_PROGS_PVT - show dependent code
Package BodyIBY_FD_USER_API_PUB - show dependent code
PL/SQL PackageIBY_PAYGROUP_PUB - show dependent code
Package BodyIBY_PAYGROUP_PUB - show dependent code
PL/SQL PackageIBY_PAYINSTR_PUB - show dependent code
Package BodyIBY_PAYINSTR_PUB - show dependent code
ViewIBY_PERIODIC_SEQ_SRS_V
PL/SQL PackageIBY_SINGPAY_PUB - show dependent code
Package BodyIBY_VALIDATIONSETS_PUB - show dependent code
PL/SQL PackageIBY_VALIDATIONSETS_PUB - show dependent code