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 HR_ORGANIZATION_INFORMATION

Line 261: from hr_organization_information

257: If P_repair_supplier_org_id is null then
258: Begin
259: Select organization_id
260: into L_repair_supplier_org_id ----> P_repair_supplier_org_id
261: from hr_organization_information
262: where ORG_INFORMATION_CONTEXT = 'Customer/Supplier Association'
263: and ORG_INFORMATION3 = P_repair_supplier_id; ---> 1159 (Vendor Id parameter)
264: Exception
265: When No_Data_Found then

Line 292: from po_vendors a, hr_organization_information b

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