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.CSP_REPAIR_PO_GRP dependencies on PO_VENDORS

Line 238: from po_vendors

234: --------------------------------------------
235: Begin
236: Select VENDOR_NAME
237: into l_VENDOR_NAME
238: from po_vendors
239: where vendor_id = P_repair_supplier_id
240: --and nvl(start_date_active,sysdate) <= nvl(end_date_active,sysdate);
241: and NVL(START_DATE_ACTIVE,SYSDATE) <= SYSDATE
242: and NVL(END_DATE_ACTIVE,SYSDATE) >= SYSDATE;

Line 287: from po_vendors a, hr_organization_information b

283: Get Vendor Id based on Repair supplier Organization Id
284: -------------------------------------------------------
285: Begin
286: select a.vendor_id
287: from po_vendors a, hr_organization_information b
288: where b.organization_id = 3201 --> P_repair_supplier_org_id (Repair supplier Org Id parameter)
289: and a.vendor_id = b.ORG_INFORMATION3
290: and b.ORG_INFORMATION_CONTEXT = 'Customer/Supplier Association'
291: and NVL(a.START_DATE_ACTIVE,SYSDATE) <= SYSDATE