DBA Data[Home] [Help]

APPS.JAI_PO_VSA_TRIGGER_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 89

     UPDATE JAI_CMN_VENDOR_SITES
     SET    inactive_flag = 'Y'
     WHERE  vendor_site_id  = pr_new.vendor_site_id;
Line: 93

     UPDATE JAI_CMN_VENDOR_SITES
     SET    inactive_flag = ''
     WHERE  vendor_site_id  = pr_new.vendor_site_id;