[Home] [Help] [Dependency Information]
Object Name: | PO_USAGE_ATTRIBUTES |
---|---|
Object Type: | TABLE |
Owner: | PO |
FND Design Data: | PO.PO_USAGE_ATTRIBUTES |
Subobject Name: | |
Status: | VALID |
PO_USAGE_ATTRIBUTES stores the relationship between note usages
stored in PO_USAGES and their attributes stored in
PO_NOTE_ATTRIBUTES. Usage attributes indicate what forms and
reports enter, view, or print notes. For instance, Oracle
Purchasing prints Note to Supplier on purchase orders. The usage for
Note to Supplier is 'Vendor' and the attribute for printing a note
on a purchase order is 'PRINTPO'. There is one row in this table
where NOTE_ATTRIBUTE is 'PRINTPO' and USAGE_ID is the identifier for
the
Usage 'Vendor'.
.
Oracle Purchasing seeds this table when you upgrade or install
Oracle Purchasing. The primary key is a concatenation of USAGE_ID
and NOTE_ATTRIBUTE. PO_USAGE_ATTRIBUTES has no foreign keys and
does not correspond to any forms.
.
.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 5 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PO_USAGE_ATTRIBUTES_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
USAGE_ID
NOTE_ATTRIBUTE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
USAGE_ID | NUMBER | Unique identifier for the note usage | ||
NOTE_ATTRIBUTE | VARCHAR2 | (30) | Note attribute | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | ||
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). |
Cut, paste (and edit) the following text to query this object:
SELECT USAGE_ID
, NOTE_ATTRIBUTE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM PO.PO_USAGE_ATTRIBUTES;
PO.PO_USAGE_ATTRIBUTES does not reference any database object
PO.PO_USAGE_ATTRIBUTES is referenced by following:
|
|
|