[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 |