[Home] [Help]
[Dependency Information]
Object Name: | IBY_PAYMENTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ![]() |
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;
|
|
|