APPS.GMIPVER SQL Statements

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

Line: 34

    SELECT decode(substr(patch_level,-1,1),'A',1,'B',2,'C',3,'D',4,'E',5,'F',6,'G',7,'H',8,'I',9,'J',10,'K',11,'L',12,'M',13,'N',14,'O',15,0)
    INTO   l_retval
    FROM   fnd_product_installations
    WHERE  application_id = 551;

Line: 41

    SELECT count(1)
    INTO   l_count
    FROM   fnd_views
    WHERE  application_id   =     552
    and    view_name      like   'GMD_QC_TESTS_VL';

Line: 50

    SELECT count(1)
    INTO   l_count
    FROM   fnd_tables
    WHERE  application_id   =     551
    and    table_name      like   'GMI_ITEMS_XML_INTERFACE';

Line: 65

    SELECT count(1)
    INTO   l_count
    FROM   fnd_tables
    WHERE  application_id   =     551
    and    table_name      like   'GMI_CATEGORY_SETS';

Line: 74

    SELECT count(1)
    INTO   l_count
    FROM   fnd_views
    WHERE  application_id   =     550
    and    view_name      like   'SY_UOMS_MST_V';