eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_OSP_ORDERS_PVT dependencies on PO_AGENTS_NAME_V

Line 310: SELECT buyer_id FROM po_agents_name_v

306: AND purchasing_site_flag = G_YES_FLAG;
307: l_vendor_site_id NUMBER;
308:
309: CURSOR po_agent_id_csr(p_buyer_name IN VARCHAR2) IS
310: SELECT buyer_id FROM po_agents_name_v
311: WHERE full_name = p_buyer_name;
312: l_po_agent_id NUMBER;
313: CURSOR customer_id_csr(p_customer_name IN VARCHAR2) IS
314: SELECT party_id from hz_parties

Line 725: SELECT 'x' FROM po_agents_name_v

721: PROCEDURE validate_buyer(
722: p_po_agent_id IN NUMBER
723: )IS
724: CURSOR val_po_agent_id_csr(p_po_agent_id IN NUMBER) IS
725: SELECT 'x' FROM po_agents_name_v
726: WHERE buyer_id = p_po_agent_id;
727: l_exist VARCHAR2(1);
728: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.validate_buyer';
729: BEGIN

Line 4294: FROM po_agents_name_v PA,

4290: l_vendor_valid_flag BOOLEAN := FALSE;
4291:
4292: CURSOR get_buyer_id IS
4293: SELECT PA.buyer_id
4294: FROM po_agents_name_v PA,
4295: fnd_user FU
4296: WHERE FU.user_id = fnd_global.user_id
4297: AND PA.buyer_id = FU.employee_id;
4298: BEGIN