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

Object Details

Object Name:	CLN_3C3_INVOICE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CLN.CLN_3C3_INVOICE_V
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DOCUMENT_TRANSFER_ID	NUMBER	(15)	Yes	Document transfer ID
CUSTOMER_TRX_ID	NUMBER	(15)	Yes	Customer Transaction ID
TERM_ID	NUMBER	(15)		Term ID
AMOUNT	NUMBER			Invoice Amount
CURRENCY_CODE	VARCHAR2	(15)		Currency Code
TRX_DATE	DATE		Yes	Transaction Date
TRX_NUMBER	VARCHAR2	(20)	Yes	Transaction Number
PO_NUMBER	VARCHAR2	(50)		Purchase Order Number
DOCUMENT_TYPE	VARCHAR2	(20)		Invoice Document Type
PAYMENT_METHOD	VARCHAR2	(30)		Payment Method
SUPPLIER_NAME	VARCHAR2	(240)	Yes	Supplier Name
SUPPLIER_CODE	VARCHAR2	(35)		Supplier Code
SALESREP	VARCHAR2	(240)		Sales Representative
SALESREP_EMAIL	VARCHAR2	(240)		Sales Representative Email
REFERENCE_NUMBER	VARCHAR2	(81)		Reference Number
BILL_TO_LOCATION_CODE	VARCHAR2	(40)		BillTo Location Code
BILL_TO_CUSTOMER_NAME	VARCHAR2	(360)	Yes	BillTo Customer Name
ORG_ID	NUMBER	(15)		Organization ID

Query Text

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


SELECT DOCUMENT_TRANSFER_ID
,      CUSTOMER_TRX_ID
,      TERM_ID
,      AMOUNT
,      CURRENCY_CODE
,      TRX_DATE
,      TRX_NUMBER
,      PO_NUMBER
,      DOCUMENT_TYPE
,      PAYMENT_METHOD
,      SUPPLIER_NAME
,      SUPPLIER_CODE
,      SALESREP
,      SALESREP_EMAIL
,      REFERENCE_NUMBER
,      BILL_TO_LOCATION_CODE
,      BILL_TO_CUSTOMER_NAME
,      ORG_ID
FROM APPS.CLN_3C3_INVOICE_V;

Dependencies

[top of page]

APPS.CLN_3C3_INVOICE_V references the following:

APPS: AR_DOCUMENT_TRANSFERS; AR_RECEIPT_METHODS; HR_ALL_ORGANIZATION_UNITS; HR_LOCATIONS_ALL; HZ_CUST_ACCOUNTS_ALL; HZ_CUST_ACCT_SITES_ALL; HZ_CUST_SITE_USES_ALL; HZ_PARTIES; RA_CUSTOMER_TRX_ALL; RA_CUSTOMER_TRX_LINES_ALL; RA_CUST_TRX_TYPES_ALL; RA_SALESREPS_ALL

APPS.CLN_3C3_INVOICE_V is referenced by following:

APPS: CLN_NTFYINVC_PKG - show dependent code