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.OKI_HPARTY_DTL_V

Object Details

Object Name:	OKI_HPARTY_DTL_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

Contains information about the parties involved in a contract like party name, role of the party (vendor,buyer,third party ) etc.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CHR_ID	NUMBER		Yes	Unique Identifier for Contract Header. Used as a join column
CONTRACT_NUMBER	VARCHAR2	(120)	Yes	Contract Number
CONTRACT_NUMBER_MODIFIER	VARCHAR2	(120)		Contract Number Modifier
COMPLETE_K_NUMBER	VARCHAR2	(241)		Complete Contract Number. Formed by concatenation of Contract Number and Contract Number Modifier
RLE_CODE	VARCHAR2	(30)	Yes	Role code for the party. Refers to lookup_code in fnd_lookups where lookup_type = OKC_ROLE
PARTY_NAME	VARCHAR2	(360)		Party Name
PARTY_NUMBER	VARCHAR2	(30)		Party Number

Query Text

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


SELECT CHR_ID
,      CONTRACT_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      COMPLETE_K_NUMBER
,      RLE_CODE
,      PARTY_NAME
,      PARTY_NUMBER
FROM APPS.OKI_HPARTY_DTL_V;

Dependencies

[top of page]

APPS.OKI_HPARTY_DTL_V references the following:

APPS: BIS_COMMON_PARAMETERS - show dependent code; HZ_CUST_ACCOUNTS; HZ_PARTIES; MTL_PARAMETERS; OKC_K_PARTY_ROLES_B; OKC_UTIL - show dependent code; OKI_ORGS_OLTP_V; OKI_SRM_006_V

APPS.OKI_HPARTY_DTL_V is not referenced by any database object