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

VIEW: APPS.IBY_TRANSACTIONS_SET_V

Object Details
Object Name: IBY_TRANSACTIONS_SET_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIBY.IBY_TRANSACTIONS_SET_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
ORDER_ID VARCHAR2 (80) Yes
MERCHANT_ID VARCHAR2 (80) Yes
VENDOR_ID NUMBER (15)
TRXN_TYPE NUMBER (15)
AMOUNT NUMBER

CURRENCY VARCHAR2 (15)
TIME DATE

STATUS NUMBER (15) Yes
SPLIT_ID NUMBER

SET_TRXN_ID VARCHAR2 (80)
BATCH_ID VARCHAR2 (80)
BATCH_SEQ_NUM NUMBER

BATCH_TRXN_STATUS NUMBER

COMPLETION_CODE VARCHAR2 (80)
CARD_BIN VARCHAR2 (10)
TERMINAL_ID VARCHAR2 (80)
REQUEST_TYPE NUMBER

SUBSEQ_AUTH_IND NUMBER

ERROR_LOCATION NUMBER

VENDOR_CODE VARCHAR2 (40)
VENDOR_MESSAGE VARCHAR2 (255)
ORG_ID NUMBER (15)
Organization identifier
Query Text

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


SELECT ORDER_ID
,      MERCHANT_ID
,      VENDOR_ID
,      TRXN_TYPE
,      AMOUNT
,      CURRENCY
,      TIME
,      STATUS
,      SPLIT_ID
,      SET_TRXN_ID
,      BATCH_ID
,      BATCH_SEQ_NUM
,      BATCH_TRXN_STATUS
,      COMPLETION_CODE
,      CARD_BIN
,      TERMINAL_ID
,      REQUEST_TYPE
,      SUBSEQ_AUTH_IND
,      ERROR_LOCATION
,      VENDOR_CODE
,      VENDOR_MESSAGE
,      ORG_ID
FROM APPS.IBY_TRANSACTIONS_SET_V;

Dependencies

[top of page]

APPS.IBY_TRANSACTIONS_SET_V references the following:

SchemaAPPS
SynonymIBY_TRXN_EXTENDED
SynonymIBY_TRXN_SUMMARIES_ALL
APPS.IBY_TRANSACTIONS_SET_V is referenced by following:

SchemaAPPS
Package BodyIBY_QUERYSET_PKG - show dependent code