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