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


VIEW: APPS.IBY_UPG_PPP_VL

Object Details
Object Name: IBY_UPG_PPP_VL
Object Type: VIEW
Owner: APPS
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
BEP_SUFFIX VARCHAR2 (10)
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
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 mode in which the payments of an instructions are logically grouped
BATCH_BOOKING_FLAG VARCHAR2 (1)
Specifes whether bank will send a statement based on payment or group
INST_GROUP_BY_PAYMENT_METHOD VARCHAR2 (1)
Specifes whether payments are grouped by payment method
POSITIVE_PAY_DELIVERY_FLAG VARCHAR2 (1) Yes
TRANSMIT_INSTR_IMMED_FLAG VARCHAR2 (1) Yes
AUTOMATIC_PI_REG_SUBMIT VARCHAR2 (1) Yes
DECLARATION_OPTION VARCHAR2 (30)
DCL_ONLY_FOREIGN_CURR_PMT_FLAG VARCHAR2 (1)
DECLARATION_REPORT_FORMAT_CODE 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)
ACK_TRANSMIT_PROTOCOL_CODE VARCHAR2 (100)
ACK_SECURITY_PROTOCOL_CODE VARCHAR2 (100)
SEND_TO_FILE_FLAG VARCHAR2 (1) Yes
PI_REGISTER_FORMAT VARCHAR2 (30)
BEP_ACCOUNT_ID NUMBER (15)
APPLICABLE_PMT_METHOD VARCHAR2 (240)
APPLICABLE_CURRENCY VARCHAR2 (240)
APPLICABLE_PAYER_ORG VARCHAR2 (240)
APPLICABLE_INT_BANK_ACCOUNT VARCHAR2 (240)
PMT_GROUP_BY_PAYMENT_DETAILS VARCHAR2 (1) Yes
PMT_GROUP_BY_BANK_CHARGE_BEAR VARCHAR2 (1) Yes
PMT_GROUP_BY_DELIVERY_CHANNEL VARCHAR2 (1) Yes
PMT_GROUP_BY_REMITTANCE_MES VARCHAR2 (1) Yes
PMT_GROUP_BY_MAX_DOCUMENTS VARCHAR2 (1) Yes
PMT_GROUP_BY_UNIQUE_REMIT_ID VARCHAR2 (1) Yes
PMT_GROUP_BY_SETTLE_PRIORITY VARCHAR2 (1) Yes
PMT_GROUP_BY_PAYMENT_REASON VARCHAR2 (1) Yes
PMT_GROUP_BY_DUE_DATE_FLAG VARCHAR2 (1) Yes
PMT_MAX_DOCUMENTS_PER_PAYMENT NUMBER (15)
PMT_PAYMENT_DETAILS_LENGTH_LIM NUMBER (15)
PMT_PAYMENT_DETAILS_FORMULA VARCHAR2 (240)
INST_GROUP_BY_PAYMENT_DATE VARCHAR2 (1) Yes
INST_GROUP_BY_PAYMENT_CURRENCY VARCHAR2 (1) Yes
INST_GROUP_BY_INT_BANK_ACCT VARCHAR2 (1) Yes
INST_GROUP_BY_MAX_PAYMENTS VARCHAR2 (1) Yes
INST_GROUP_BY_PAY_SERVICE_REQ VARCHAR2 (1) Yes
INST_GROUP_BY_LEGAL_ENTITY VARCHAR2 (1) Yes
INST_GROUP_BY_BILL_PAYABLE VARCHAR2 (1) Yes
INST_GROUP_BY_MAX_INSTRUCTION VARCHAR2 (1) Yes
INST_GROUP_BY_ORGANIZATION VARCHAR2 (1) Yes
INST_GROUP_BY_PAYMENT_FUNCTION VARCHAR2 (1) Yes
INST_GROUP_BY_PAYMENT_REASON VARCHAR2 (1) Yes
INST_GROUP_BY_RFC VARCHAR2 (1) Yes
INST_MAX_PAYMENTS_PER_INSTR NUMBER (15)
INST_MAX_AMOUNT_PER_INSTR_VAL NUMBER (15)
INST_MAX_AMOUNT_PER_INSTR_CURR VARCHAR2 (10)
INST_MAX_AMOUNT_FX_RATE_TYPE VARCHAR2 (30)
INST_SORT_OPTION_1 VARCHAR2 (30)
INST_SORT_ORDER_1 VARCHAR2 (30)
INST_SORT_OPTION_2 VARCHAR2 (30)
INST_SORT_ORDER_2 VARCHAR2 (30)
INST_SORT_OPTION_3 VARCHAR2 (30)
INST_SORT_ORDER_3 VARCHAR2 (30)
REMIT_DOCUMENT_COUNT_LIMIT NUMBER

REMIT_ALLOW_MULTIPLE_COPY_FLAG VARCHAR2 (1)
REMIT_PMT_DETAILS_LENGTH_LIM NUMBER

REMIT_REMITTANCE_ADVICE_FORMAT VARCHAR2 (30)
REMIT_SRA_OVERRIDE_PAYEE_FLAG VARCHAR2 (1) Yes
REMIT_ADVICE_DELIVERY_METHOD VARCHAR2 (100)
REMIT_AUTOMATIC_SRA_SUBMIT VARCHAR2 (1) Yes Y or N flag indicating whether the remittance advice should be submitted automatically at payment completion point.
SYSTEM_PROFILE_NAME VARCHAR2 (100) Yes
SYSTEM_PROFILE_DESCRIPTION VARCHAR2 (255)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (15) Yes
ELECTRONIC_PROCESSING_CHANNEL VARCHAR2 (50)
INACTIVE_DATE DATE

Query Text

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


SELECT SYSTEM_PROFILE_CODE
,      BEP_SUFFIX
,      SECURITY_PROTOCOL_CODE
,      TRANSMIT_PROTOCOL_CODE
,      PAYMENT_FORMAT_CODE
,      POSITIVE_PAY_FORMAT_CODE
,      PAY_FILE_LETTER_FORMAT_CODE
,      PRINT_INSTRUCTION_IMMED_FLAG
,      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
,      INST_GROUP_BY_PAYMENT_METHOD
,      POSITIVE_PAY_DELIVERY_FLAG
,      TRANSMIT_INSTR_IMMED_FLAG
,      AUTOMATIC_PI_REG_SUBMIT
,      DECLARATION_OPTION
,      DCL_ONLY_FOREIGN_CURR_PMT_FLAG
,      DECLARATION_REPORT_FORMAT_CODE
,      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
,      ACK_TRANSMIT_PROTOCOL_CODE
,      ACK_SECURITY_PROTOCOL_CODE
,      SEND_TO_FILE_FLAG
,      PI_REGISTER_FORMAT
,      BEP_ACCOUNT_ID
,      APPLICABLE_PMT_METHOD
,      APPLICABLE_CURRENCY
,      APPLICABLE_PAYER_ORG
,      APPLICABLE_INT_BANK_ACCOUNT
,      PMT_GROUP_BY_PAYMENT_DETAILS
,      PMT_GROUP_BY_BANK_CHARGE_BEAR
,      PMT_GROUP_BY_DELIVERY_CHANNEL
,      PMT_GROUP_BY_REMITTANCE_MES
,      PMT_GROUP_BY_MAX_DOCUMENTS
,      PMT_GROUP_BY_UNIQUE_REMIT_ID
,      PMT_GROUP_BY_SETTLE_PRIORITY
,      PMT_GROUP_BY_PAYMENT_REASON
,      PMT_GROUP_BY_DUE_DATE_FLAG
,      PMT_MAX_DOCUMENTS_PER_PAYMENT
,      PMT_PAYMENT_DETAILS_LENGTH_LIM
,      PMT_PAYMENT_DETAILS_FORMULA
,      INST_GROUP_BY_PAYMENT_DATE
,      INST_GROUP_BY_PAYMENT_CURRENCY
,      INST_GROUP_BY_INT_BANK_ACCT
,      INST_GROUP_BY_MAX_PAYMENTS
,      INST_GROUP_BY_PAY_SERVICE_REQ
,      INST_GROUP_BY_LEGAL_ENTITY
,      INST_GROUP_BY_BILL_PAYABLE
,      INST_GROUP_BY_MAX_INSTRUCTION
,      INST_GROUP_BY_ORGANIZATION
,      INST_GROUP_BY_PAYMENT_FUNCTION
,      INST_GROUP_BY_PAYMENT_REASON
,      INST_GROUP_BY_RFC
,      INST_MAX_PAYMENTS_PER_INSTR
,      INST_MAX_AMOUNT_PER_INSTR_VAL
,      INST_MAX_AMOUNT_PER_INSTR_CURR
,      INST_MAX_AMOUNT_FX_RATE_TYPE
,      INST_SORT_OPTION_1
,      INST_SORT_ORDER_1
,      INST_SORT_OPTION_2
,      INST_SORT_ORDER_2
,      INST_SORT_OPTION_3
,      INST_SORT_ORDER_3
,      REMIT_DOCUMENT_COUNT_LIMIT
,      REMIT_ALLOW_MULTIPLE_COPY_FLAG
,      REMIT_PMT_DETAILS_LENGTH_LIM
,      REMIT_REMITTANCE_ADVICE_FORMAT
,      REMIT_SRA_OVERRIDE_PAYEE_FLAG
,      REMIT_ADVICE_DELIVERY_METHOD
,      REMIT_AUTOMATIC_SRA_SUBMIT
,      SYSTEM_PROFILE_NAME
,      SYSTEM_PROFILE_DESCRIPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      ELECTRONIC_PROCESSING_CHANNEL
,      INACTIVE_DATE
FROM APPS.IBY_UPG_PPP_VL;

Dependencies

[top of page]

APPS.IBY_UPG_PPP_VL references the following:

SchemaAPPS
SynonymIBY_UPG_PPP_B
SynonymIBY_UPG_PPP_TL

APPS.IBY_UPG_PPP_VL is not referenced by any database object