[Home] [Help]
View: POBV_BUYERS
Product: | PO - Purchasing |
Description: | - Retrofitted |
Implementation/DBA Data: |
APPS.POBV_BUYERS
|
View Text
SELECT BR.AGENT_ID
, PP.EMPLOYEE_NUMBER
, PP.FULL_NAME
, BR.AUTHORIZATION_LIMIT
, BR.START_DATE_ACTIVE
, BR.END_DATE_ACTIVE
, BR.CATEGORY_ID
, BR.LOCATION_ID
, BR.CREATION_DATE
, BR.CREATED_BY
, BR.LAST_UPDATE_DATE
, BR.LAST_UPDATED_BY
FROM PO_AGENTS BR
, PER_PEOPLE_F PP
WHERE BR.AGENT_ID = PP.PERSON_ID
AND PP.EFFECTIVE_START_DATE <= TRUNC(SYSDATE)
AND PP.EFFECTIVE_END_DATE >= TRUNC(SYSDATE) WITH READ ONLY
Columns
Name |
BUYER_ID |
BUYER_EMPLOYEE_NUMBER |
BUYER_NAME |
AUTHORIZATION_LIMIT |
START_EFFECTIVE_DATE |
END_EFFECTIVE_DATE |
CATEGORY_ID |
LOCATION_ID |
CREATED_DATE |
CREATED_BY |
LAST_UPDATED_DATE |
LAST_UPDATED_BY |