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: ViewAR.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:

SchemaAPPS
ViewAR_LOOKUPS
SynonymAR_PAYMENT_SCHEDULES_ALL
SynonymAR_RECEIVABLE_APPLICATIONS_ALL
SynonymHZ_CUST_ACCOUNTS_ALL
SynonymHZ_PARTIES
SynonymRA_CUSTOMER_TRX_ALL

APPS.AR_OEX_CM_VIEW is not referenced by any database object