FND Design Data [Home] [Help]

View: POA_BIS_SAVINGS_BUYER_LOV_V

Product: PO - Purchasing
Description:
Implementation/DBA Data: Not implemented in this database
View Text

SELECT HR.PERSON_ID
, HR.FULL_NAME NAME
FROM PO_AGENTS POA
, PER_ALL_PEOPLE_F HR
WHERE POA.AGENT_ID = HR.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN HR.EFFECTIVE_START_DATE
AND HR.EFFECTIVE_END_DATE

Columns

Name
BUYER_ID
BUYER_NAME