[Home] [Help] [Dependency Information]
Object Name: | PAY_GB_SOY_OUTPUTS |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PAY.PAY_GB_SOY_OUTPUTS |
Subobject Name: | |
Status: | VALID |
PAY_GB_SOY_OUTPUTS is a temporary table for the GB Start of Year (SOY)
process outputs. It is populated by the SOY process data, and
includes errors or warnings relating to the update processes. This
table is redundant if you write to multiple files concurrently from
PLSQL.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 20 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PAY_GB_SOY_OUTPUTS_PK | NORMAL | UNIQUE | APPS_TS_INTERFACE |
REQUEST_ID
TYPE LINE_NO |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TYPE | VARCHAR2 | (30) | Yes | Type of report for the outputs. |
LINE_NO | NUMBER | Yes | Line number within the appropriate SOY report output. | |
TEXT | VARCHAR2 | (132) | Free format text for SOY report. | |
REQUEST_ID | NUMBER | (15) | Yes | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). |
Cut, paste (and edit) the following text to query this object:
SELECT TYPE
, LINE_NO
, TEXT
, REQUEST_ID
FROM HR.PAY_GB_SOY_OUTPUTS;
HR.PAY_GB_SOY_OUTPUTS does not reference any database object
HR.PAY_GB_SOY_OUTPUTS is referenced by following:
|
|
|