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.FA_VENDORMERGE_GRP dependencies on FA_LEASES

Line 190: -- Updating FA_LEASES : LESSOR_ID, LESSOR_SITE_ID

186: set PO_VENDOR_ID = p_vendor_id
187: where PO_VENDOR_ID = p_dup_vendor_id;
188:
189: -- **********************************************************
190: -- Updating FA_LEASES : LESSOR_ID, LESSOR_SITE_ID
191: -- **********************************************************
192: l_location := 'FA_LEASES';
193: update FA_LEASES
194: set LESSOR_ID = p_vendor_id

Line 192: l_location := 'FA_LEASES';

188:
189: -- **********************************************************
190: -- Updating FA_LEASES : LESSOR_ID, LESSOR_SITE_ID
191: -- **********************************************************
192: l_location := 'FA_LEASES';
193: update FA_LEASES
194: set LESSOR_ID = p_vendor_id
195: , LESSOR_SITE_ID = decode(LESSOR_SITE_ID, p_dup_vendor_site_id, p_vendor_site_id, LESSOR_SITE_ID)
196: where LESSOR_ID = p_dup_vendor_id

Line 193: update FA_LEASES

189: -- **********************************************************
190: -- Updating FA_LEASES : LESSOR_ID, LESSOR_SITE_ID
191: -- **********************************************************
192: l_location := 'FA_LEASES';
193: update FA_LEASES
194: set LESSOR_ID = p_vendor_id
195: , LESSOR_SITE_ID = decode(LESSOR_SITE_ID, p_dup_vendor_site_id, p_vendor_site_id, LESSOR_SITE_ID)
196: where LESSOR_ID = p_dup_vendor_id
197: and nvl(LESSOR_SITE_ID, 0) = decode(LESSOR_SITE_ID, NULL, 0, p_dup_vendor_site_id);