[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | FTP_IRC_ADI_RATE_T |
|---|---|
| Object Type: | TABLE |
| Owner: | FTP |
| Subobject Name: | |
| Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| EFFECTIVE_DATE | DATE | Yes | ||
| INTEREST_RATE_CODE | NUMBER | Yes | ||
| INTEREST_RATE_NAME | VARCHAR2 | (60) | ||
| INTEREST_RATE_FORMAT | VARCHAR2 | (60) | ||
| COMPOUND_BASIS | VARCHAR2 | (60) | ||
| ACCRUAL_BASIS | VARCHAR2 | (60) | ||
| REFERENCE_CURRENCY | VARCHAR2 | (60) | ||
| CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | Yes | ||
| LAST_UPDATED_BY | NUMBER | Yes | ||
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATE_LOGIN | NUMBER | |||
| OBJECT_VERSION_NUMBER | NUMBER | |||
| STATUS | VARCHAR2 | (30) | ||
| INTEREST_RATE1 | NUMBER | (10) | ||
| INTEREST_RATE2 | NUMBER | (10) | ||
| INTEREST_RATE3 | NUMBER | (10) | ||
| INTEREST_RATE4 | NUMBER | (10) | ||
| INTEREST_RATE5 | NUMBER | (10) | ||
| INTEREST_RATE6 | NUMBER | (10) | ||
| INTEREST_RATE7 | NUMBER | (10) | ||
| INTEREST_RATE8 | NUMBER | (10) | ||
| INTEREST_RATE9 | NUMBER | (10) | ||
| INTEREST_RATE10 | NUMBER | (10) | ||
| INTEREST_RATE11 | NUMBER | (10) | ||
| INTEREST_RATE12 | NUMBER | (10) | ||
| INTEREST_RATE13 | NUMBER | (10) | ||
| INTEREST_RATE14 | NUMBER | (10) | ||
| INTEREST_RATE15 | NUMBER | (10) | ||
| INTEREST_RATE16 | NUMBER | (10) | ||
| INTEREST_RATE17 | NUMBER | (10) | ||
| INTEREST_RATE18 | NUMBER | (10) | ||
| INTEREST_RATE19 | NUMBER | (10) | ||
| INTEREST_RATE20 | NUMBER | (10) | ||
| INTEREST_RATE21 | NUMBER | (10) | ||
| INTEREST_RATE22 | NUMBER | (10) | ||
| INTEREST_RATE23 | NUMBER | (10) | ||
| INTEREST_RATE24 | NUMBER | (10) | ||
| INTEREST_RATE25 | NUMBER | (10) | ||
| INTEREST_RATE26 | NUMBER | (10) | ||
| INTEREST_RATE27 | NUMBER | (10) | ||
| INTEREST_RATE28 | NUMBER | (10) | ||
| INTEREST_RATE29 | NUMBER | (10) | ||
| INTEREST_RATE30 | NUMBER | (10) | ||
| INTEREST_RATE31 | NUMBER | (10) | ||
| INTEREST_RATE32 | NUMBER | (10) | ||
| INTEREST_RATE33 | NUMBER | (10) | ||
| INTEREST_RATE34 | NUMBER | (10) | ||
| INTEREST_RATE35 | NUMBER | (10) | ||
| INTEREST_RATE36 | NUMBER | (10) | ||
| INTEREST_RATE37 | NUMBER | (10) | ||
| INTEREST_RATE38 | NUMBER | (10) | ||
| INTEREST_RATE39 | NUMBER | (10) | ||
| INTEREST_RATE40 | NUMBER | (10) | ||
| INTEREST_RATE41 | NUMBER | (10) | ||
| INTEREST_RATE42 | NUMBER | (10) | ||
| INTEREST_RATE43 | NUMBER | (10) | ||
| INTEREST_RATE44 | NUMBER | (10) | ||
| INTEREST_RATE45 | NUMBER | (10) | ||
| INTEREST_RATE46 | NUMBER | (10) | ||
| INTEREST_RATE47 | NUMBER | (10) | ||
| INTEREST_RATE48 | NUMBER | (10) | ||
| INTEREST_RATE49 | NUMBER | (10) | ||
| INTEREST_RATE50 | NUMBER | (10) | ||
| INTEREST_RATE51 | NUMBER | (10) | ||
| INTEREST_RATE52 | NUMBER | (10) | ||
| INTEREST_RATE53 | NUMBER | (10) | ||
| INTEREST_RATE54 | NUMBER | (10) | ||
| INTEREST_RATE55 | NUMBER | (10) | ||
| INTEREST_RATE56 | NUMBER | (10) | ||
| INTEREST_RATE57 | NUMBER | (10) | ||
| INTEREST_RATE58 | NUMBER | (10) | ||
| INTEREST_RATE59 | NUMBER | (10) | ||
| INTEREST_RATE60 | NUMBER | (10) | ||
| INTEREST_RATE61 | NUMBER | (10) | ||
| INTEREST_RATE62 | NUMBER | (10) | ||
| INTEREST_RATE63 | NUMBER | (10) | ||
| INTEREST_RATE64 | NUMBER | (10) | ||
| INTEREST_RATE65 | NUMBER | (10) | ||
| INTEREST_RATE66 | NUMBER | (10) | ||
| INTEREST_RATE67 | NUMBER | (10) | ||
| INTEREST_RATE68 | NUMBER | (10) | ||
| INTEREST_RATE69 | NUMBER | (10) | ||
| INTEREST_RATE70 | NUMBER | (10) | ||
| INTEREST_RATE71 | NUMBER | (10) | ||
| INTEREST_RATE72 | NUMBER | (10) | ||
| INTEREST_RATE73 | NUMBER | (10) | ||
| INTEREST_RATE74 | NUMBER | (10) | ||
| INTEREST_RATE75 | NUMBER | (10) | ||
| INTEREST_RATE76 | NUMBER | (10) | ||
| INTEREST_RATE77 | NUMBER | (10) | ||
| INTEREST_RATE78 | NUMBER | (10) | ||
| INTEREST_RATE79 | NUMBER | (10) | ||
| INTEREST_RATE80 | NUMBER | (10) | ||
| INTEREST_RATE81 | NUMBER | (10) | ||
| INTEREST_RATE82 | NUMBER | (10) | ||
| INTEREST_RATE83 | NUMBER | (10) | ||
| INTEREST_RATE84 | NUMBER | (10) | ||
| INTEREST_RATE85 | NUMBER | (10) | ||
| INTEREST_RATE86 | NUMBER | (10) | ||
| INTEREST_RATE87 | NUMBER | (10) | ||
| INTEREST_RATE88 | NUMBER | (10) | ||
| INTEREST_RATE89 | NUMBER | (10) | ||
| INTEREST_RATE90 | NUMBER | (10) | ||
| INTEREST_RATE91 | NUMBER | (10) | ||
| INTEREST_RATE92 | NUMBER | (10) | ||
| INTEREST_RATE93 | NUMBER | (10) | ||
| INTEREST_RATE94 | NUMBER | (10) | ||
| INTEREST_RATE95 | NUMBER | (10) | ||
| INTEREST_RATE96 | NUMBER | (10) | ||
| INTEREST_RATE97 | NUMBER | (10) | ||
| INTEREST_RATE98 | NUMBER | (10) | ||
| INTEREST_RATE99 | NUMBER | (10) | ||
| INTEREST_RATE100 | NUMBER | (10) |
Cut, paste (and edit) the following text to query this object:
SELECT EFFECTIVE_DATE
, INTEREST_RATE_CODE
, INTEREST_RATE_NAME
, INTEREST_RATE_FORMAT
, COMPOUND_BASIS
, ACCRUAL_BASIS
, REFERENCE_CURRENCY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, STATUS
, INTEREST_RATE1
, INTEREST_RATE2
, INTEREST_RATE3
, INTEREST_RATE4
, INTEREST_RATE5
, INTEREST_RATE6
, INTEREST_RATE7
, INTEREST_RATE8
, INTEREST_RATE9
, INTEREST_RATE10
, INTEREST_RATE11
, INTEREST_RATE12
, INTEREST_RATE13
, INTEREST_RATE14
, INTEREST_RATE15
, INTEREST_RATE16
, INTEREST_RATE17
, INTEREST_RATE18
, INTEREST_RATE19
, INTEREST_RATE20
, INTEREST_RATE21
, INTEREST_RATE22
, INTEREST_RATE23
, INTEREST_RATE24
, INTEREST_RATE25
, INTEREST_RATE26
, INTEREST_RATE27
, INTEREST_RATE28
, INTEREST_RATE29
, INTEREST_RATE30
, INTEREST_RATE31
, INTEREST_RATE32
, INTEREST_RATE33
, INTEREST_RATE34
, INTEREST_RATE35
, INTEREST_RATE36
, INTEREST_RATE37
, INTEREST_RATE38
, INTEREST_RATE39
, INTEREST_RATE40
, INTEREST_RATE41
, INTEREST_RATE42
, INTEREST_RATE43
, INTEREST_RATE44
, INTEREST_RATE45
, INTEREST_RATE46
, INTEREST_RATE47
, INTEREST_RATE48
, INTEREST_RATE49
, INTEREST_RATE50
, INTEREST_RATE51
, INTEREST_RATE52
, INTEREST_RATE53
, INTEREST_RATE54
, INTEREST_RATE55
, INTEREST_RATE56
, INTEREST_RATE57
, INTEREST_RATE58
, INTEREST_RATE59
, INTEREST_RATE60
, INTEREST_RATE61
, INTEREST_RATE62
, INTEREST_RATE63
, INTEREST_RATE64
, INTEREST_RATE65
, INTEREST_RATE66
, INTEREST_RATE67
, INTEREST_RATE68
, INTEREST_RATE69
, INTEREST_RATE70
, INTEREST_RATE71
, INTEREST_RATE72
, INTEREST_RATE73
, INTEREST_RATE74
, INTEREST_RATE75
, INTEREST_RATE76
, INTEREST_RATE77
, INTEREST_RATE78
, INTEREST_RATE79
, INTEREST_RATE80
, INTEREST_RATE81
, INTEREST_RATE82
, INTEREST_RATE83
, INTEREST_RATE84
, INTEREST_RATE85
, INTEREST_RATE86
, INTEREST_RATE87
, INTEREST_RATE88
, INTEREST_RATE89
, INTEREST_RATE90
, INTEREST_RATE91
, INTEREST_RATE92
, INTEREST_RATE93
, INTEREST_RATE94
, INTEREST_RATE95
, INTEREST_RATE96
, INTEREST_RATE97
, INTEREST_RATE98
, INTEREST_RATE99
, INTEREST_RATE100
FROM FTP.FTP_IRC_ADI_RATE_T;
FTP.FTP_IRC_ADI_RATE_T does not reference any database object
FTP.FTP_IRC_ADI_RATE_T is referenced by following:
APPS
FTP_IRC_ADI_RATE_T
|
|
|
|