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

VIEW: APPS.IBY_TRXN_EXT_SETTLEMENTS_V

Object Details
Object Name: IBY_TRXN_EXT_SETTLEMENTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIBY.IBY_TRXN_EXT_SETTLEMENTS_V
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
SETTLEMENT_ID NUMBER
Yes
TRXN_EXTENSION_ID NUMBER (15) Yes
SETTLEMENT_GROUP_ID NUMBER

PAYMENT_CHANNEL_CODE VARCHAR2 (30) Yes
INSTR_ASSIGNMENT_ID NUMBER (15)
SETTLEMENT_RESULT_CODE VARCHAR2 (21)
SETTLEMENT_DATE DATE

PMT_SYS_ERR_CODE VARCHAR2 (40)
PMT_SYS_ERR_MSG VARCHAR2 (255)
PAYMENT_SYSTEM_ORDER_NUMBER VARCHAR2 (80) Yes
PAYEE_ID VARCHAR2 (80) Yes
ORG_TYPE VARCHAR2 (30)
ORG_ID NUMBER (15)
INITIATOR_EXTENSION_ID NUMBER (15)
ORIGIN_APPLICATION_ID NUMBER
Yes
Query Text

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


SELECT SETTLEMENT_ID
,      TRXN_EXTENSION_ID
,      SETTLEMENT_GROUP_ID
,      PAYMENT_CHANNEL_CODE
,      INSTR_ASSIGNMENT_ID
,      SETTLEMENT_RESULT_CODE
,      SETTLEMENT_DATE
,      PMT_SYS_ERR_CODE
,      PMT_SYS_ERR_MSG
,      PAYMENT_SYSTEM_ORDER_NUMBER
,      PAYEE_ID
,      ORG_TYPE
,      ORG_ID
,      INITIATOR_EXTENSION_ID
,      ORIGIN_APPLICATION_ID
FROM APPS.IBY_TRXN_EXT_SETTLEMENTS_V;

Dependencies

[top of page]

APPS.IBY_TRXN_EXT_SETTLEMENTS_V references the following:

SchemaAPPS
SynonymIBY_FNDCPT_TX_EXTENSIONS
SynonymIBY_FNDCPT_TX_OPERATIONS
SynonymIBY_TRXN_SUMMARIES_ALL
APPS.IBY_TRXN_EXT_SETTLEMENTS_V is referenced by following:

SchemaAPPS
Package BodyIBY_FNDCPT_TRXN_PUB - show dependent code