[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_IL0000394195C00003$$ | LOB | UNIQUE | APPS_TS_TX_DATA |
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 | |
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). |
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;
AR.AR_IREC_PRINT_REQUESTS does not reference any database object
AR.AR_IREC_PRINT_REQUESTS is referenced by following:
|
|
|