Table Details - PO_AGENTS

Table: PO_AGENTS

Description:Buyers table
Primary Key: PO_AGENTS_PK
  1. AGENT_ID
Foreign Keys from this table:
Foreign Key ColumnForeign Table
PO_AGENTS.CATEGORY_IDMTL_CATEGORIES_B
Foreign Keys to this table:
Foreign Key ColumnForeign Table
AHL_OSP_ORDERS_B.PO_AGENT_IDPO_AGENTS
MRP_SYSTEM_ITEMS.BUYER_IDPO_AGENTS
PO_HEADERS_ARCHIVE_ALL.AGENT_IDPO_AGENTS
PO_HEADERS_DRAFT_ALL.AGENT_IDPO_AGENTS
PO_HEADERS_ALL.AGENT_IDPO_AGENTS
PO_RELEASES_ALL.HOLD_BYPO_AGENTS
PO_RELEASES_ALL.AGENT_IDPO_AGENTS
PO_REQEXPRESS_LINES_ALL.SUGGESTED_BUYER_IDPO_AGENTS
PO_REQUISITIONS_INTERFACE_ALL.SUGGESTED_BUYER_IDPO_AGENTS
PO_REQUISITION_LINES_ALL.SUGGESTED_BUYER_IDPO_AGENTS
PO_VENDORS.HOLD_BYPO_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
IndexTypeTablespaceColumn
PO_AGENTS_U1UNIQUEAPPS_TS_TX_IDXAGENT_ID
Columns
NameDatatypeLengthMandatoryComments
AGENT_IDNUMBER(9)YBuyer unique identifier
LAST_UPDATE_DATEDATE
YStandard Who column - date when a user last updated this row.
LAST_UPDATED_BYNUMBER
YStandard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGINNUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATEDATE

Standard who column - date when this row was created.
CREATED_BYNUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LOCATION_IDNUMBER

Location unique identifier
CATEGORY_IDNUMBER

Item category unique identifier
AUTHORIZATION_LIMITNUMBER

Maximum purchase order authorization limit for the buyer
START_DATE_ACTIVEDATE

Key Flexfield start date
END_DATE_ACTIVEDATE

Key Flexfield end date
ATTRIBUTE_CATEGORYVARCHAR2(240)
Descriptive flexfield structure definition column.
ATTRIBUTE1VARCHAR2(150)
Descriptive flexfield segment
ATTRIBUTE2VARCHAR2(150)
Descriptive flexfield segment
ATTRIBUTE3VARCHAR2(150)
Descriptive flexfield segment
ATTRIBUTE4VARCHAR2(150)
Descriptive flexfield segment
ATTRIBUTE5VARCHAR2(150)
Descriptive flexfield segment
ATTRIBUTE6VARCHAR2(150)
Descriptive flexfield segment
ATTRIBUTE7VARCHAR2(150)
Descriptive flexfield segment
ATTRIBUTE8VARCHAR2(150)
Descriptive flexfield segment
ATTRIBUTE9VARCHAR2(150)
Descriptive flexfield segment
ATTRIBUTE10VARCHAR2(150)
Descriptive flexfield segment
ATTRIBUTE11VARCHAR2(150)
Descriptive flexfield segment
ATTRIBUTE12VARCHAR2(150)
Descriptive flexfield segment
ATTRIBUTE13VARCHAR2(150)
Descriptive flexfield segment
ATTRIBUTE14VARCHAR2(150)
Descriptive flexfield segment
ATTRIBUTE15VARCHAR2(150)
Descriptive flexfield segment
REQUEST_IDNUMBER

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_IDNUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_IDNUMBER

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_DATEDATE

Concurrent Program who column - date when a program last updated this row).
IS_CONTRACT_OFFICERVARCHAR2(1)
This user is a contracting officer or not (Y/N)
WARRANT_IDNUMBER

Id of the Warrant issued to the contracting officer user.

[top of page]

PO.PO_AGENTS does not reference any database object