[Home] [Help]
[Dependency Information]
| Object Name: | IBY_PAYMENTS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: | IBY.IBY_PAYMENTS_V
|
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TRANSACTIONID | NUMBER | Yes | ||
| PAYEEID | VARCHAR2 | (80) | Yes | |
| ECAPPID | NUMBER | (15) | Yes | |
| SCHEDDATE | DATE | |||
| SCHEDMODE | VARCHAR2 | (7) | ||
| NLSLANG | VARCHAR2 | (80) | ||
| PAYMENTMETHODNAME | VARCHAR2 | (80) | ||
| TANGIBLEID | VARCHAR2 | (80) | Yes | |
| AMOUNT | NUMBER | Yes | ||
| CURRENCYNAMECODE | VARCHAR2 | (15) | Yes | |
| ACCTNO | VARCHAR2 | (80) | ||
| REFINFO | VARCHAR2 | (80) | ||
| MEMO | VARCHAR2 | (80) | ||
| PAYERID | VARCHAR2 | (80) | ||
| PAYERINSTRID | NUMBER | |||
| INSTRTYPE | VARCHAR2 | (30) | ||
| ORG_ID | NUMBER | (15) | Organization identifier |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTIONID
, PAYEEID
, ECAPPID
, SCHEDDATE
, SCHEDMODE
, NLSLANG
, PAYMENTMETHODNAME
, TANGIBLEID
, AMOUNT
, CURRENCYNAMECODE
, ACCTNO
, REFINFO
, MEMO
, PAYERID
, PAYERINSTRID
, INSTRTYPE
, ORG_ID
FROM APPS.IBY_PAYMENTS_V;
APPS
IBY_TANGIBLE
IBY_TRXN_SUMMARIES_ALL
APPS
IBY_PAYMENT_ADAPTER_PUB
- show dependent code
|
|
|
|