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

Object Details

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

This view is used in service contract authoring to display all the customer accounts and related customer accounts for the parties(Other than Vendor Role) selected in the contract.

[View Source]

Columns

Name	Datatype	Length	Comments
ACCOUNT_NAME	VARCHAR2	(240)	Account Name
ACCOUNT_NUMBER	VARCHAR2	(30)	Account Number
ID1	NUMBER	(15)
ID2	CHAR	(1)
PARTY_NAME	VARCHAR2	(360)
PARTY_ID	NUMBER	(15)
PARTY_NUMBER	VARCHAR2	(30)

Query Text

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


SELECT ACCOUNT_NAME
,      ACCOUNT_NUMBER
,      ID1
,      ID2
,      PARTY_NAME
,      PARTY_ID
,      PARTY_NUMBER
FROM APPS.OKS_AUTH_PARTYACCTS_V;

Dependencies

[top of page]

APPS.OKS_AUTH_PARTYACCTS_V references the following:

APPS: HZ_CUST_ACCOUNTS; HZ_CUST_ACCT_RELATE_ALL; HZ_PARTIES; OKC_CONTEXT - show dependent code; OKS_AUTH_PARTY_GROUPS

APPS.OKS_AUTH_PARTYACCTS_V is not referenced by any database object