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.

[Home] [Help]

View: OKX_CUST_TRX_TYPES_V

Product:	OKX - Contracts Integration
Description:	Transaction type for customer's invoices, commitments and credit memos
Implementation/DBA Data:	APPS.OKX_CUST_TRX_TYPES_V

View Text

SELECT CTT.CUST_TRX_TYPE_ID ID1
, '#' ID2
, CTT.STATUS STATUS
, CTT.NAME NAME
, CTT.DESCRIPTION DESCRIPTION
, CTT.TYPE TYPE
, CTT.START_DATE START_DATE_ACTIVE
, CTT.END_DATE END_DATE_ACTIVE
, CTT.SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, CTT.ORG_ID ORG_ID
FROM RA_CUST_TRX_TYPES_ALL CTT

Columns

Name
ID1
ID2
STATUS
NAME
DESCRIPTION
TYPE
START_DATE_ACTIVE
END_DATE_ACTIVE
SET_OF_BOOKS_ID
ORG_ID