DBA Data[Home] [Help]

APPS.GML_PROCESS_FLAGS SQL Statements

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

Line: 12

     SELECT distinct segment1
     FROM   mtl_system_items_b
     WHERE  inventory_item_id = nvl(p_inventory_item_id,-99);
Line: 17

	SELECT count(*)
                FROM ic_item_mst
                WHERE item_no = v_item_no;
Line: 56

     SELECT process_enabled_flag
     FROM   mtl_parameters
     WHERE  organization_id = nvl(p_organization_id,-99);