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

Object Details

Object Name:	OKL_CS_TRX_PAYMENTS_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_CS_TRX_PAYMENTS_UV
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	Comments
RECEIVABLE_APPLICATION_ID	NUMBER
TRANSACTION_TYPE	VARCHAR2	(150)
INVOICE_NUMBER	VARCHAR2	(150)
INVOICE_DATE	DATE
TRANSACTION_AMOUNT	NUMBER
AMOUNT_APPLIED	NUMBER
AMOUNT_REMAINING	NUMBER
PAYMENT_METHOD	VARCHAR2	(30)
RECEIPT_NUMBER	VARCHAR2	(30)
RECEIPT_AMOUNT	NUMBER
UNAPPLIED_AMOUNT	NUMBER		Receipt unapplied amount
ONACCOUNT_AMOUNT	NUMBER		Receipt On Account Amount
RECEIPT_DATE	DATE
CONTRACT_NUMBER	VARCHAR2	(150)	Contract Number
DUE_DATE	DATE
PAYMENT_APPLICATION_DATE	DATE
APPLICATION_STATUS	VARCHAR2	(80)
LINE_IDENTIFIER	VARCHAR2	(40)
RECEIPT_CURRENCY_CODE	VARCHAR2	(15)
INVOICE_CURRENCY_CODE	VARCHAR2	(15)
RECEIPT_METHOD_ID	NUMBER	(15)
CASH_RECEIPT_ID	NUMBER	(15)
INVOICE_ID	NUMBER		Foreign key to view OKL_CNSLD_AR_HDRS_V
KHR_ID	NUMBER		Foreign key to view OKL_K_HEADERS_V
CUST_ACCOUNT_ID	NUMBER	(15)
RECEIPT_TYPE_CODE	VARCHAR2	(3)	Receipt Type Code
ORG_ID	NUMBER	(15)
CUSTOMER_ID	NUMBER	(15)
RECEIPT_STATUS_CODE	VARCHAR2	(30)
RECEIPT_STATUS	VARCHAR2	(80)
INVOICE_LINE_ID	NUMBER
ADVANCED_YN	VARCHAR2	(80)
CUSTOMER_ACCOUNT_NUMBER	VARCHAR2	(30)

Query Text

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


SELECT RECEIVABLE_APPLICATION_ID
,      TRANSACTION_TYPE
,      INVOICE_NUMBER
,      INVOICE_DATE
,      TRANSACTION_AMOUNT
,      AMOUNT_APPLIED
,      AMOUNT_REMAINING
,      PAYMENT_METHOD
,      RECEIPT_NUMBER
,      RECEIPT_AMOUNT
,      UNAPPLIED_AMOUNT
,      ONACCOUNT_AMOUNT
,      RECEIPT_DATE
,      CONTRACT_NUMBER
,      DUE_DATE
,      PAYMENT_APPLICATION_DATE
,      APPLICATION_STATUS
,      LINE_IDENTIFIER
,      RECEIPT_CURRENCY_CODE
,      INVOICE_CURRENCY_CODE
,      RECEIPT_METHOD_ID
,      CASH_RECEIPT_ID
,      INVOICE_ID
,      KHR_ID
,      CUST_ACCOUNT_ID
,      RECEIPT_TYPE_CODE
,      ORG_ID
,      CUSTOMER_ID
,      RECEIPT_STATUS_CODE
,      RECEIPT_STATUS
,      INVOICE_LINE_ID
,      ADVANCED_YN
,      CUSTOMER_ACCOUNT_NUMBER
FROM APPS.OKL_CS_TRX_PAYMENTS_UV;

Dependencies

[top of page]

APPS.OKL_CS_TRX_PAYMENTS_UV references the following:

APPS: AR_ACTIVITY_DETAILS; AR_CASH_RECEIPTS_ALL; AR_CASH_RECEIPT_HISTORY_ALL; AR_LOOKUPS; AR_PAYMENT_SCHEDULES_ALL; AR_RECEIPT_METHODS; AR_RECEIVABLE_APPLICATIONS_ALL; FND_GLOBAL - show dependent code; FND_LOOKUPS; HZ_CUST_ACCOUNTS; OKC_K_HEADERS_ALL_B; OKL_TRX_CSH_RCPT_ALL_B; OKL_TXL_RCPT_APPS_ALL_B; RA_CUSTOMER_TRX_ALL; RA_CUSTOMER_TRX_LINES_ALL

APPS.OKL_CS_TRX_PAYMENTS_UV is referenced by following:

APPS: OKL_CS_CONT_INV_RECEIPTS_UV; OKL_CS_INV_RECEIPTS_UV