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

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PARTY_NAME	VARCHAR2	(360)	Yes	Name of this party
CM_INTERFACE_HEADER_CONTEXT	VARCHAR2	(30)		Interface header context
OEX_BILL_TO_PARTY_ID	VARCHAR2	(150)		Interface header attribute value
OEX_BILL_TO_SITE_USE_ID	VARCHAR2	(150)		Interface header attribute value
AR_BILL_TO_PARTY_ID	NUMBER	(15)		Customer identifier
AR_BILL_TO_SITE_USE_ID	NUMBER	(15)		Site use identifier billed
BILLING_INTERFACE_REQUEST_ID	VARCHAR2	(150)		Interface header attribute value
BILLING_PERIOD	VARCHAR2	(150)		Interface header attribute value
CM_CUSTOMER_TRX_ID	NUMBER	(15)	Yes	Invoice identifier
CM_TRX_DATE	DATE		Yes	Invoice date
CM_TRX_NUMBER	VARCHAR2	(20)	Yes	Transaction number
CM_TRX_STATUS	VARCHAR2	(30)	Yes	Lookup code for the status of the item
CM_TRX_CLASS_CODE	VARCHAR2	(20)	Yes	Lookup code for the class of the payment schedule
CM_TRX_CLASS_NAME	VARCHAR2	(80)	Yes	Description of the Quickcode
CM_APPLY_DATE	DATE			Date the application was applied
CM_AMOUNT_APPLIED	NUMBER			For same currency applications, the total amount of the application in the currency of the receipt and transaction. For cross currency applications, the total amount of the application in the currency of the transaction.
CM_AMOUNT_DUE_ORIGINAL	NUMBER		Yes	The original amount due
CM_AMOUNT_DUE_REMAINING	NUMBER		Yes	The current amount due remaining
INV_CUSTOMER_TRX_ID	NUMBER	(15)		Invoice identifier
INV_TRX_DATE	DATE			Invoice date
INV_TRX_NUMBER	VARCHAR2	(20)		Transaction number
ORG_ID	NUMBER	(15)		Organization identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).

Query Text

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


SELECT PARTY_NAME
,      CM_INTERFACE_HEADER_CONTEXT
,      OEX_BILL_TO_PARTY_ID
,      OEX_BILL_TO_SITE_USE_ID
,      AR_BILL_TO_PARTY_ID
,      AR_BILL_TO_SITE_USE_ID
,      BILLING_INTERFACE_REQUEST_ID
,      BILLING_PERIOD
,      CM_CUSTOMER_TRX_ID
,      CM_TRX_DATE
,      CM_TRX_NUMBER
,      CM_TRX_STATUS
,      CM_TRX_CLASS_CODE
,      CM_TRX_CLASS_NAME
,      CM_APPLY_DATE
,      CM_AMOUNT_APPLIED
,      CM_AMOUNT_DUE_ORIGINAL
,      CM_AMOUNT_DUE_REMAINING
,      INV_CUSTOMER_TRX_ID
,      INV_TRX_DATE
,      INV_TRX_NUMBER
,      ORG_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM APPS.AR_OEX_CM_VIEW;

Dependencies

[top of page]

APPS.AR_OEX_CM_VIEW references the following:

APPS: AR_LOOKUPS; AR_PAYMENT_SCHEDULES_ALL; AR_RECEIVABLE_APPLICATIONS_ALL; HZ_CUST_ACCOUNTS_ALL; HZ_PARTIES; RA_CUSTOMER_TRX_ALL

APPS.AR_OEX_CM_VIEW is not referenced by any database object