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 257: from hr_organization_information

253: ---------------------------------------------------------------
254: Begin
255: Select organization_id
256: into L_repair_supplier_org_id ----> P_repair_supplier_org_id
257: from hr_organization_information
258: where ORG_INFORMATION_CONTEXT = 'Customer/Supplier Association'
259: and ORG_INFORMATION3 = P_repair_supplier_id; ---> 1159 (Vendor Id parameter)
260: Exception
261: When No_Data_Found then

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