eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.UMX_ORGANIZATION_PVT_V

Object Details

Object Name:	UMX_ORGANIZATION_PVT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FND.UMX_ORGANIZATION_PVT_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PARTY_ID	NUMBER	(15)	Yes	Party Id
PARTY_NAME	VARCHAR2	(360)	Yes	Party Name
PARTY_NUMBER	VARCHAR2	(30)	Yes	Party Number
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
WH_UPDATE_DATE	DATE			See documentation for HZ_PARTIES
REQUEST_ID	NUMBER	(15)		See documentation for HZ_PARTIES
PROGRAM_APPLICATION_ID	NUMBER	(15)		See documentation for HZ_PARTIES
PROGRAM_ID	NUMBER	(15)		See documentation for HZ_PARTIES
PROGRAM_UPDATE_DATE	DATE			See documentation for HZ_PARTIES
KNOWN_AS	VARCHAR2	(240)		See documentation for HZ_PARTIES
TAX_NAME	VARCHAR2	(60)		See documentation for HZ_PARTIES
TAX_REFERENCE	VARCHAR2	(50)		See documentation for HZ_PARTIES
JGZZ_FISCAL_CODE	VARCHAR2	(20)		See documentation for HZ_PARTIES
KNOWN_AS2	VARCHAR2	(240)		See documentation for HZ_PARTIES
KNOWN_AS3	VARCHAR2	(240)		See documentation for HZ_PARTIES
KNOWN_AS4	VARCHAR2	(240)		See documentation for HZ_PARTIES
KNOWN_AS5	VARCHAR2	(240)		See documentation for HZ_PARTIES
STATUS	VARCHAR2	(1)	Yes	See documentation for HZ_PARTIES
OBJECT_VERSION_NUMBER	NUMBER			See documentation for HZ_PARTIES
CREATED_BY_MODULE	VARCHAR2	(150)		See documentation for HZ_PARTIES
ORIG_SYSTEM_REFERENCE	VARCHAR2	(240)	Yes	See documentation for HZ_PARTIES
APPLICATION_ID	NUMBER			See documentation for HZ_PARTIES
COUNTRY	VARCHAR2	(60)		See documentation for HZ_PARTIES
ADDRESS1	VARCHAR2	(240)		See documentation for HZ_PARTIES
ADDRESS2	VARCHAR2	(240)		See documentation for HZ_PARTIES
ADDRESS3	VARCHAR2	(240)		See documentation for HZ_PARTIES
ADDRESS4	VARCHAR2	(240)		See documentation for HZ_PARTIES
CITY	VARCHAR2	(60)		See documentation for HZ_PARTIES
POSTAL_CODE	VARCHAR2	(60)		See documentation for HZ_PARTIES
STATE	VARCHAR2	(60)		See documentation for HZ_PARTIES
PROVINCE	VARCHAR2	(60)		See documentation for HZ_PARTIES
COUNTY	VARCHAR2	(60)		See documentation for HZ_PARTIES
EMAIL_ADDRESS	VARCHAR2	(2000)		See documentation for HZ_PARTIES
ORGANIZATION_NAME_PHONETIC	VARCHAR2	(320)		See documentation for HZ_PARTIES
LANGUAGE_NAME	VARCHAR2	(4)		See documentation for HZ_PARTIES
CATEGORY_CODE	VARCHAR2	(30)		See documentation for HZ_PARTIES
ANALYSIS_FY	VARCHAR2	(5)		See documentation for HZ_PARTIES
FISCAL_YEAREND_MONTH	VARCHAR2	(30)		See documentation for HZ_PARTIES
EMPLOYEES_TOTAL	NUMBER			See documentation for HZ_PARTIES
CURR_FY_POTENTIAL_REVENUE	NUMBER			See documentation for HZ_PARTIES
NEXT_FY_POTENTIAL_REVENUE	NUMBER			See documentation for HZ_PARTIES
YEAR_ESTABLISHED	NUMBER	(4)		See documentation for HZ_PARTIES
GSA_INDICATOR_FLAG	VARCHAR2	(1)		See documentation for HZ_PARTIES
MISSION_STATEMENT	VARCHAR2	(2000)		See documentation for HZ_PARTIES
DUNS_NUMBER	NUMBER			See documentation for HZ_PARTIES
COMPETITOR_FLAG	VARCHAR2	(1)		See documentation for HZ_PARTIES
THIRD_PARTY_FLAG	VARCHAR2	(1)		See documentation for HZ_PARTIES
REFERENCE_USE_FLAG	VARCHAR2	(1)		See documentation for HZ_PARTIES
SIC_CODE_TYPE	VARCHAR2	(30)		See documentation for HZ_PARTIES

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PARTY_ID
,      PARTY_NAME
,      PARTY_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      WH_UPDATE_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      KNOWN_AS
,      TAX_NAME
,      TAX_REFERENCE
,      JGZZ_FISCAL_CODE
,      KNOWN_AS2
,      KNOWN_AS3
,      KNOWN_AS4
,      KNOWN_AS5
,      STATUS
,      OBJECT_VERSION_NUMBER
,      CREATED_BY_MODULE
,      ORIG_SYSTEM_REFERENCE
,      APPLICATION_ID
,      COUNTRY
,      ADDRESS1
,      ADDRESS2
,      ADDRESS3
,      ADDRESS4
,      CITY
,      POSTAL_CODE
,      STATE
,      PROVINCE
,      COUNTY
,      EMAIL_ADDRESS
,      ORGANIZATION_NAME_PHONETIC
,      LANGUAGE_NAME
,      CATEGORY_CODE
,      ANALYSIS_FY
,      FISCAL_YEAREND_MONTH
,      EMPLOYEES_TOTAL
,      CURR_FY_POTENTIAL_REVENUE
,      NEXT_FY_POTENTIAL_REVENUE
,      YEAR_ESTABLISHED
,      GSA_INDICATOR_FLAG
,      MISSION_STATEMENT
,      DUNS_NUMBER
,      COMPETITOR_FLAG
,      THIRD_PARTY_FLAG
,      REFERENCE_USE_FLAG
,      SIC_CODE_TYPE
FROM APPS.UMX_ORGANIZATION_PVT_V;

Dependencies

[top of page]

APPS.UMX_ORGANIZATION_PVT_V references the following:

APPS: HZ_PARTIES

APPS.UMX_ORGANIZATION_PVT_V is not referenced by any database object