Now you can Subscribe using RSS

Submit your Email

Thursday 15 September 2016

Query to find - Is an employer also a buyer or not in oracle Apps or How can check that employee is a buyer

Query to find Is an employee also a buyer or not In Oracle Apps R12?

Query -

SELECT pa.agent_id, papf.person_id, papf.employee_number, papf.email_address,
       pa.category_id, pa.location_id, papf.effective_start_date,
  FROM po_agents pa, per_all_people_f papf, hr_all_organization_units haou
 WHERE pa.agent_id = papf.person_id
   AND papf.business_group_id = haou.business_group_id
   AND TRUNC (SYSDATE) BETWEEN papf.effective_start_date
                           AND papf.effective_end_date
--AND    email_address = ''

“A GUIDE FOR ORACLE E-BUSINESS SUITE” –A complete Solution and Learning platform For Oracle Apps R12/11i, Training, India Localization, Technical, P2P, O2C, Drop-shipment, AR/AP Cycle, Implementation, Bug or error in Oracle Apps R12/11i, Up-gradation, Support, Alert, Personalization, Discoverer management, OracleApps R12/11i Module, Finance, SCM, MRP, ASCP, WIP, BOM, FA, AP, AR, OM, INV, AOL, MOAC, TCA structure, Project Accounting, CM, Functional,Oracle DBA, ERP, Techno-functional, OAF, Oracle Apps Interview Question and Error in Oracle apps R12/11i. For More Information Visit on Or Subscribe your email-id on OracleAppsGuide


Post a Comment ©Coprights 2013,