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]

TABLE: APPS.AR_IL_CASH_RECEIPTS_GT

Object Details

Object Name:	AR_IL_CASH_RECEIPTS_GT
Object Type:	TABLE
Owner:	APPS
FND Design Data:	FND.AR_IL_CASH_RECEIPTS_GT
Subobject Name:
Status:	VALID

This is a global temporary table, used for israeli receipt printing program.

Temporary Table Details

APPS.AR_IL_CASH_RECEIPTS_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Columns

Name	Datatype	Length	Comments
CASH_RECEIPT_ID	NUMBER	(15)	Cash Receipt Id
RECEIPT_NUMBER	VARCHAR2	(30)
RECEIPT_DATE	DATE		Receipt Date
RECEIPT_STATUS	VARCHAR2	(30)	Receipt Status
DOCUMENT_NUMBER	NUMBER	(15)	Document Number
RECEIPT_AMOUNT	NUMBER		Receipt Amount
CURRENCY	VARCHAR2	(15)	Currency
CREDIT_CARD_NO	VARCHAR2	(150)	Credit Card Number
CREDIT_CARD_TYPE	VARCHAR2	(150)	Credit Card Type
MATURITY_DATE	DATE		Maturity Date
METHOD_NAME	VARCHAR2	(30)	Method Name
BANK_ACCOUNT	VARCHAR2	(30)
BANK_NAME	VARCHAR2	(360)	Bank Name
BANK_BRANCH_NAME	VARCHAR2	(360)	Bank Branch Name
CUSTOMER_NAME	VARCHAR2	(360)	Customer Name
CUSTOMER_NUMBER	VARCHAR2	(30)	Customer Number
TAX_REGISTRATION_NUMBER	VARCHAR2	(50)	Tax Registration Number
CUST_ACCOUNT_ID	NUMBER	(15)	Customer Account Id
CUST_ACCT_SITE_ID	NUMBER	(15)	Customer Account Site Id
ADDRESS_LINE1	VARCHAR2	(600)	Customer Address Line1
ADDRESS_LINE2	VARCHAR2	(240)	Customer Address Line2
USER_NAME	VARCHAR2	(150)	User Name
ATTRIBUTE1	VARCHAR2	(150)	Attribute1
ATTRIBUTE2	VARCHAR2	(150)	Attribute2
CITY	VARCHAR2	(150)	City
POSTAL_CODE	VARCHAR2	(150)	Postal Code
COPY_OR_ORIGINAL	VARCHAR2	(150)	Copy or Original

Query Text

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


SELECT CASH_RECEIPT_ID
,      RECEIPT_NUMBER
,      RECEIPT_DATE
,      RECEIPT_STATUS
,      DOCUMENT_NUMBER
,      RECEIPT_AMOUNT
,      CURRENCY
,      CREDIT_CARD_NO
,      CREDIT_CARD_TYPE
,      MATURITY_DATE
,      METHOD_NAME
,      BANK_ACCOUNT
,      BANK_NAME
,      BANK_BRANCH_NAME
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      TAX_REGISTRATION_NUMBER
,      CUST_ACCOUNT_ID
,      CUST_ACCT_SITE_ID
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      USER_NAME
,      ATTRIBUTE1
,      ATTRIBUTE2
,      CITY
,      POSTAL_CODE
,      COPY_OR_ORIGINAL
FROM APPS.AR_IL_CASH_RECEIPTS_GT;

Dependencies

[top of page]

APPS.AR_IL_CASH_RECEIPTS_GT does not reference any database object

APPS.AR_IL_CASH_RECEIPTS_GT is referenced by following:

APPS: AR_CASH_RECEIPT_PRINT_PKG - show dependent code