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: AR.AR_IREC_PRINT_REQUESTS

Object Details

Object Name:	AR_IREC_PRINT_REQUESTS
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.AR_IREC_PRINT_REQUESTS
Subobject Name:
Status:	VALID

This table stores all transaction print requests submitted by iReceivables users. The table also holds the print output of BPA immediate prints.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000394195C00003$$	LOB	UNIQUE	APPS_TS_TX_DATA

Columns

Name	Datatype	Length	Mandatory	Comments
FILE_NAME	VARCHAR2	(255)		The File Name generated through BPA Immediate Print Request. The file name will be like BPA.pdf
FILE_CONTENT_TYPE	VARCHAR2	(255)		Content type as specified during the uploading process. This string is an unparsed entity-header for the entity "Content-Type", and specifies the content type, and any additional parameters (such as character set) that describe the stored contents.
FILE_DATA	BLOB	(4000)		The uploaded data itself, which is a binary LOB
UPLOAD_DATE	DATE			Timestamp at which the LOB was uploaded
PROGRAM_NAME	VARCHAR2	(240)		Name of the program on whose behalf the LOB is being maintained.
REQUESTED_BY	VARCHAR2	(40)		The user(FND_USER.USER_ID) who has requested the Print Request
LANGUAGE	VARCHAR2	(15)		Language of file
ORACLE_CHARSET	VARCHAR2	(30)		Oracle character set of file
FILE_FORMAT	VARCHAR2	(15)		File format ('text' or 'binary')
REQUEST_ID	NUMBER		Yes	The Print Request Identifier
CUSTOMER_ID	NUMBER		Yes	The Print Request made on the Customer Account Id
CUSTOMER_SITE_USE_ID	NUMBER			The Print Request made on the Customer Account Site Use Id
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

Query Text

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


SELECT FILE_NAME
,      FILE_CONTENT_TYPE
,      FILE_DATA
,      UPLOAD_DATE
,      PROGRAM_NAME
,      REQUESTED_BY
,      LANGUAGE
,      ORACLE_CHARSET
,      FILE_FORMAT
,      REQUEST_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_USE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM AR.AR_IREC_PRINT_REQUESTS;

Dependencies

[top of page]

AR.AR_IREC_PRINT_REQUESTS does not reference any database object

AR.AR_IREC_PRINT_REQUESTS is referenced by following:

APPS: AR_IREC_PRINT_REQUESTS