[Home] [Help] [Dependency Information]
Object Name: | OKX_CUSTOMER_TRX_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKX.OKX_CUSTOMER_TRX_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Displays customer's invoice, debit memo, commitment, and credit memo header information. Each row includes general invoice information.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CUSTOMER_TRX_ID | NUMBER | (15) | Yes | Invoice identifier |
TRX_NUMBER | VARCHAR2 | (20) | Yes | Transaction number |
CUST_TRX_TYPE_ID | NUMBER | (15) | Yes | Transaction type identifier |
TRX_DATE | DATE | Yes | Invoice date | |
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Set of books identifier |
ORG_ID | NUMBER | (15) | Operating Unit Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT CUSTOMER_TRX_ID
, TRX_NUMBER
, CUST_TRX_TYPE_ID
, TRX_DATE
, SET_OF_BOOKS_ID
, ORG_ID
FROM APPS.OKX_CUSTOMER_TRX_V;
APPS.OKX_CUSTOMER_TRX_V is not referenced by any database object
|
|
|