[Home] [Help]
[Dependency Information]
VIEW: XTR.XTR_PORTFOLIO_DEAL_AMOUNTS#
Object Details
Object Name: | XTR_PORTFOLIO_DEAL_AMOUNTS# |
Object Type: | VIEW |
Owner: | XTR |
Subobject Name: | |
Status: | VALID |
[View Source]
Columns
Name |
Datatype |
Length |
Mandatory |
Comments |
COMPANY_CODE |
VARCHAR2 |
(7) |
Yes |
|
DEAL_NUMBER |
NUMBER |
|
Yes |
|
PERCENTAGE_SPLIT |
NUMBER |
|
Yes |
|
PORTFOLIO_CODE |
VARCHAR2 |
(7) |
Yes |
|
TRANSACTION_NUMBER |
NUMBER |
|
Yes |
|
Query Text
Cut, paste (and edit) the following text to query this object:
SELECT COMPANY_CODE
, DEAL_NUMBER
, PERCENTAGE_SPLIT
, PORTFOLIO_CODE
, TRANSACTION_NUMBER
FROM XTR.XTR_PORTFOLIO_DEAL_AMOUNTS#;
Dependencies
[top of page]
XTR.XTR_PORTFOLIO_DEAL_AMOUNTS# references the following:
-
XTR
-
XTR_PORTFOLIO_DEAL_AMOUNTS
XTR.XTR_PORTFOLIO_DEAL_AMOUNTS# is referenced by following:
-
APPS
-
XTR_PORTFOLIO_DEAL_AMOUNTS