Table: PO_AGENTS
Primary Key: PO_AGENTS_PK
- AGENT_ID
Foreign Keys from this table:
| Foreign Key Column | Foreign Table |
|---|
| PO_AGENTS.CATEGORY_ID | MTL_CATEGORIES_B |
Foreign Keys to this table:
| Foreign Key Column | Foreign Table |
|---|
| AHL_OSP_ORDERS_B.PO_AGENT_ID | PO_AGENTS |
| MRP_SYSTEM_ITEMS.BUYER_ID | PO_AGENTS |
| PO_HEADERS_ARCHIVE_ALL.AGENT_ID | PO_AGENTS |
| PO_HEADERS_DRAFT_ALL.AGENT_ID | PO_AGENTS |
| PO_HEADERS_ALL.AGENT_ID | PO_AGENTS |
| PO_RELEASES_ALL.HOLD_BY | PO_AGENTS |
| PO_RELEASES_ALL.AGENT_ID | PO_AGENTS |
| PO_REQEXPRESS_LINES_ALL.SUGGESTED_BUYER_ID | PO_AGENTS |
| PO_REQUISITIONS_INTERFACE_ALL.SUGGESTED_BUYER_ID | PO_AGENTS |
| PO_REQUISITION_LINES_ALL.SUGGESTED_BUYER_ID | PO_AGENTS |
| PO_VENDORS.HOLD_BY | PO_AGENTS |
Comments
PO_AGENTS contains information about buyers and purchasing managers.
You need one row for each employee who has purchasing responsibilities
in your organization. You define a buyer by entering a default Item
Category and Ship-To Location.
.
Oracle Purchasing uses this information to determine active buyers
and to provide defaults in the Find Requisitions Lines window. When
creating a purchase order, you can use the list
of values to choose a buyer you defined in this table.
.
You enter buyer information in the Buyers window.
.
The primary key AGENT_ID has the same value as the EMPLOYEE_ID in the
HR_EMPLOYEES view for the corresponding employee.
.
.
Indexes
| Index | Type | Tablespace | Column |
|---|
| PO_AGENTS_U1 | UNIQUE | APPS_TS_TX_IDX | AGENT_ID |
Columns
| Name | Datatype | Length | Mandatory | Comments |
|---|
| AGENT_ID | NUMBER | (9) | Y | Buyer unique identifier |
| LAST_UPDATE_DATE | DATE |
| Y | Standard Who column - date when a user last updated this row. |
| LAST_UPDATED_BY | NUMBER |
| Y | 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). |
| LOCATION_ID | NUMBER |
|
| Location unique identifier |
| CATEGORY_ID | NUMBER |
|
| Item category unique identifier |
| AUTHORIZATION_LIMIT | NUMBER |
|
| Maximum purchase order authorization limit for the buyer |
| START_DATE_ACTIVE | DATE |
|
| Key Flexfield start date |
| END_DATE_ACTIVE | DATE |
|
| Key Flexfield end date |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (240) |
| Descriptive flexfield structure definition column. |
| ATTRIBUTE1 | VARCHAR2 | (150) |
| Descriptive flexfield segment |
| ATTRIBUTE2 | VARCHAR2 | (150) |
| Descriptive flexfield segment |
| ATTRIBUTE3 | VARCHAR2 | (150) |
| Descriptive flexfield segment |
| ATTRIBUTE4 | VARCHAR2 | (150) |
| Descriptive flexfield segment |
| ATTRIBUTE5 | VARCHAR2 | (150) |
| Descriptive flexfield segment |
| ATTRIBUTE6 | VARCHAR2 | (150) |
| Descriptive flexfield segment |
| ATTRIBUTE7 | VARCHAR2 | (150) |
| Descriptive flexfield segment |
| ATTRIBUTE8 | VARCHAR2 | (150) |
| Descriptive flexfield segment |
| ATTRIBUTE9 | VARCHAR2 | (150) |
| Descriptive flexfield segment |
| ATTRIBUTE10 | VARCHAR2 | (150) |
| Descriptive flexfield segment |
| ATTRIBUTE11 | VARCHAR2 | (150) |
| Descriptive flexfield segment |
| ATTRIBUTE12 | VARCHAR2 | (150) |
| Descriptive flexfield segment |
| ATTRIBUTE13 | VARCHAR2 | (150) |
| Descriptive flexfield segment |
| ATTRIBUTE14 | VARCHAR2 | (150) |
| Descriptive flexfield segment |
| ATTRIBUTE15 | VARCHAR2 | (150) |
| Descriptive flexfield segment |
| 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). |
| IS_CONTRACT_OFFICER | VARCHAR2 | (1) |
| This user is a contracting officer or not (Y/N) |
| WARRANT_ID | NUMBER |
|
| Id of the Warrant issued to the contracting officer user. |
[top of page]
PO.PO_AGENTS does not reference any database object