[Home] [Help] [Dependency Information]

TABLE: IBY.IBY_UPG_PPP_B

Object Details

Object Name:	IBY_UPG_PPP_B
Object Type:	TABLE
Owner:	IBY
FND Design Data:	IBY.IBY_UPG_PPP_B
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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IBY_UPG_PPP_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SYSTEM_PROFILE_CODE

Columns

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
,      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
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      ELECTRONIC_PROCESSING_CHANNEL
,      LOGICAL_GROUPING_MODE
,      BATCH_BOOKING_FLAG
,      INST_GROUP_BY_PAYMENT_METHOD
,      INACTIVE_DATE
FROM IBY.IBY_UPG_PPP_B;

Dependencies

[top of page]

IBY.IBY_UPG_PPP_B does not reference any database object

IBY.IBY_UPG_PPP_B is referenced by following:

IBY

IBY_UPG_PPP_B#