DBA Data[Home] [Help]

APPS.FA_VENDORMERGE_GRP dependencies on FA_MASS_ADDITIONS

Line 226: -- Updating FA_MASS_ADDITIONS : PO_VENDOR_ID, LESSOR_ID, VENDOR_NUMBER

222: set PO_VENDOR_ID = p_vendor_id
223: where PO_VENDOR_ID = p_dup_vendor_id;
224:
225: -- **********************************************************
226: -- Updating FA_MASS_ADDITIONS : PO_VENDOR_ID, LESSOR_ID, VENDOR_NUMBER
227: -- **********************************************************
228: l_location := 'FA_MASS_ADDITIONS';
229: update FA_MASS_ADDITIONS
230: set PO_VENDOR_ID = decode(PO_VENDOR_ID, p_dup_vendor_id, p_vendor_id, PO_VENDOR_ID)

Line 228: l_location := 'FA_MASS_ADDITIONS';

224:
225: -- **********************************************************
226: -- Updating FA_MASS_ADDITIONS : PO_VENDOR_ID, LESSOR_ID, VENDOR_NUMBER
227: -- **********************************************************
228: l_location := 'FA_MASS_ADDITIONS';
229: update FA_MASS_ADDITIONS
230: set PO_VENDOR_ID = decode(PO_VENDOR_ID, p_dup_vendor_id, p_vendor_id, PO_VENDOR_ID)
231: , LESSOR_ID = decode(LESSOR_ID, p_dup_vendor_id, p_vendor_id, LESSOR_ID)
232: , VENDOR_NUMBER = decode(PO_VENDOR_ID, p_dup_vendor_id,

Line 229: update FA_MASS_ADDITIONS

225: -- **********************************************************
226: -- Updating FA_MASS_ADDITIONS : PO_VENDOR_ID, LESSOR_ID, VENDOR_NUMBER
227: -- **********************************************************
228: l_location := 'FA_MASS_ADDITIONS';
229: update FA_MASS_ADDITIONS
230: set PO_VENDOR_ID = decode(PO_VENDOR_ID, p_dup_vendor_id, p_vendor_id, PO_VENDOR_ID)
231: , LESSOR_ID = decode(LESSOR_ID, p_dup_vendor_id, p_vendor_id, LESSOR_ID)
232: , VENDOR_NUMBER = decode(PO_VENDOR_ID, p_dup_vendor_id,
233: decode(VENDOR_NUMBER, NULL, NULL, p_segment1),