DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OKX_CUST_TRX_TYPES_V

Object Details
Object Name: OKX_CUST_TRX_TYPES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_CUST_TRX_TYPES_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Displays information about each transaction type used for invoices, commitments and credit memos.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ID1 NUMBER (15) Yes Transaction type identifier
ID2 CHAR (1)
-
STATUS VARCHAR2 (30)
Transaction type status flag. Lookup code for 'CODE_STATUS'
NAME VARCHAR2 (20)
Transaction type name
DESCRIPTION VARCHAR2 (80)
Transaction type description
TYPE VARCHAR2 (20)
Transaction Class, could be one of: INV,CM,DM,GUAR,DEP,CB
START_DATE_ACTIVE DATE
Yes Transaction type start date
END_DATE_ACTIVE DATE

Transaction type end date
SET_OF_BOOKS_ID NUMBER (15)
Set of books identifier
ORG_ID NUMBER (15)
Operating Unit Identifier
Query Text

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


SELECT ID1
,      ID2
,      STATUS
,      NAME
,      DESCRIPTION
,      TYPE
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      SET_OF_BOOKS_ID
,      ORG_ID
FROM APPS.OKX_CUST_TRX_TYPES_V;

Dependencies

[top of page]

APPS.OKX_CUST_TRX_TYPES_V references the following:

SchemaAPPS
SynonymRA_CUST_TRX_TYPES_ALL
APPS.OKX_CUST_TRX_TYPES_V is referenced by following:

SchemaAPPS
Package BodyOKL_ACC_CALL_PVT - show dependent code
Package BodyOKL_BILL_UPFRONT_TAX_PVT - show dependent code
Package BodyOKL_INTERNAL_BILLING_PVT - show dependent code
Package BodyOKL_INTERNAL_TO_EXTERNAL - show dependent code
Package BodyOKL_INVESTOR_BILLING_PVT - show dependent code
Package BodyOKL_REBOOK_CM_PVT - show dependent code
Package BodyOKL_STREAM_BILLING_PVT - show dependent code