[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | XTR_A_PARTY_INFO_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  XTR.XTR_A_PARTY_INFO_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 |
|---|---|---|---|---|
| PARTY_CODE | VARCHAR2 | (7) | Yes | |
| PARTY_TYPE | VARCHAR2 | (2) | Yes | |
| SHORT_NAME | VARCHAR2 | (20) | Yes | |
| FULL_NAME | VARCHAR2 | (50) | Yes | |
| CREATED_BY | VARCHAR2 | (30) | Yes | |
| CREATED_ON | DATE | Yes | ||
| RISK_PARTY | VARCHAR2 | (1) | ||
| DEFAULT_COMPANY | VARCHAR2 | (1) | ||
| UPDATED_BY | VARCHAR2 | (30) | ||
| UPDATED_ON | DATE | |||
| CONTACT_NAME | VARCHAR2 | (50) | ||
| PHONE_NUMBER | VARCHAR2 | (15) | ||
| FAX_NUMBER | VARCHAR2 | (15) | ||
| ADDRESS_1 | VARCHAR2 | (50) | ||
| ADDRESS_2 | VARCHAR2 | (50) | ||
| ADDRESS_3 | VARCHAR2 | (50) | ||
| ADDRESS_4 | VARCHAR2 | (50) | ||
| ADDRESS_5 | VARCHAR2 | (50) | ||
| ADDRESS_6 | VARCHAR2 | (50) | ||
| COUNTRY_CODE | VARCHAR2 | (2) | ||
| AUTHORISED | VARCHAR2 | (1) | ||
| TAX_NUMBER | VARCHAR2 | (20) | ||
| INTERNAL_PTY | VARCHAR2 | (1) | ||
| PARTY_CATEGORY | VARCHAR2 | (2) | ||
| BROKER | VARCHAR2 | (1) | ||
| CLIENT_YN | VARCHAR2 | (1) | ||
| CROSS_REF_TO_OTHER_PARTY | VARCHAR2 | (7) | ||
| CLIENT_GROUPING | VARCHAR2 | (7) | ||
| STATE_CODE | VARCHAR2 | (3) | ||
| TITLE_DESCRIPTION | VARCHAR2 | (50) | ||
| PARTY_GROUP | VARCHAR2 | (7) | ||
| SETTLEMENT_DEFAULT_CATEGORY | VARCHAR2 | (7) | ||
| TAX_CATEGORY | VARCHAR2 | (7) | ||
| BROKERAGE_CATEGORY | VARCHAR2 | (7) | ||
| TAX_EXEMPTION_CODE | VARCHAR2 | (15) | ||
| CLIENT_ADVICE | VARCHAR2 | (1) | ||
| CLIENT_AGENT1 | VARCHAR2 | (20) | ||
| CLIENT_AGENT2 | VARCHAR2 | (20) | ||
| CLIENT_AGENT3 | VARCHAR2 | (20) | ||
| ACCOUNT_MANAGER | VARCHAR2 | (20) | ||
| ADVISOR_YN | VARCHAR2 | (1) | ||
| VALUER_YN | VARCHAR2 | (1) | ||
| P_ADDRESS_1 | VARCHAR2 | (50) | ||
| P_ADDRESS_2 | VARCHAR2 | (50) | ||
| P_ADDRESS_3 | VARCHAR2 | (50) | ||
| P_ADDRESS_4 | VARCHAR2 | (50) | ||
| EMAIL_ADDRESS | VARCHAR2 | (40) | ||
| DEPOSIT_REF | VARCHAR2 | (10) | ||
| COMMENTS | VARCHAR2 | (255) | ||
| ACCOUNT_STATUS | VARCHAR2 | (14) | ||
| CONFO_GROUP_CODE | VARCHAR2 | (20) | ||
| CONFO_ACTION_CODE | VARCHAR2 | (20) | ||
| PI_CONSTANT | VARCHAR2 | (1) | ||
| PAGER_NUMBER | NUMBER | |||
| BRANCH_SUBSIDIARY_CODE | VARCHAR2 | (7) | ||
| BRANCH_SUBSIDIARY_YN | VARCHAR2 | (1) | ||
| DEFAULT_ADDRESS_DETAILS | VARCHAR2 | (1) | ||
| SWIFT_ID | VARCHAR2 | (11) | ||
| FX_MATCH_ID | VARCHAR2 | (11) | ||
| AUDIT_INDICATOR | VARCHAR2 | (1) | ||
| AUDIT_DATE_STORED | DATE | |||
| FX_CPARTY | VARCHAR2 | (1) | ||
| MM_CPARTY | VARCHAR2 | (1) | ||
| LEGAL_ENTITY_ID | NUMBER | (15) | ||
| SUSPENSE_CCID | NUMBER | (15) | ||
| CONVERSION_TYPE | VARCHAR2 | (30) | ||
| SET_OF_BOOKS_ID | NUMBER | (15) | ||
| CHART_OF_ACCOUNTS_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT PARTY_CODE
, PARTY_TYPE
, SHORT_NAME
, FULL_NAME
, CREATED_BY
, CREATED_ON
, RISK_PARTY
, DEFAULT_COMPANY
, UPDATED_BY
, UPDATED_ON
, CONTACT_NAME
, PHONE_NUMBER
, FAX_NUMBER
, ADDRESS_1
, ADDRESS_2
, ADDRESS_3
, ADDRESS_4
, ADDRESS_5
, ADDRESS_6
, COUNTRY_CODE
, AUTHORISED
, TAX_NUMBER
, INTERNAL_PTY
, PARTY_CATEGORY
, BROKER
, CLIENT_YN
, CROSS_REF_TO_OTHER_PARTY
, CLIENT_GROUPING
, STATE_CODE
, TITLE_DESCRIPTION
, PARTY_GROUP
, SETTLEMENT_DEFAULT_CATEGORY
, TAX_CATEGORY
, BROKERAGE_CATEGORY
, TAX_EXEMPTION_CODE
, CLIENT_ADVICE
, CLIENT_AGENT1
, CLIENT_AGENT2
, CLIENT_AGENT3
, ACCOUNT_MANAGER
, ADVISOR_YN
, VALUER_YN
, P_ADDRESS_1
, P_ADDRESS_2
, P_ADDRESS_3
, P_ADDRESS_4
, EMAIL_ADDRESS
, DEPOSIT_REF
, COMMENTS
, ACCOUNT_STATUS
, CONFO_GROUP_CODE
, CONFO_ACTION_CODE
, PI_CONSTANT
, PAGER_NUMBER
, BRANCH_SUBSIDIARY_CODE
, BRANCH_SUBSIDIARY_YN
, DEFAULT_ADDRESS_DETAILS
, SWIFT_ID
, FX_MATCH_ID
, AUDIT_INDICATOR
, AUDIT_DATE_STORED
, FX_CPARTY
, MM_CPARTY
, LEGAL_ENTITY_ID
, SUSPENSE_CCID
, CONVERSION_TYPE
, SET_OF_BOOKS_ID
, CHART_OF_ACCOUNTS_ID
FROM APPS.XTR_A_PARTY_INFO_V;
APPS
XTR_A_PARTY_INFO
APPS.XTR_A_PARTY_INFO_V is not referenced by any database object
|
|
|
|