APPS.BOM_EAMUTIL SQL Statements

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

Line: 68

  SELECT   decode(effectivity_control , 2 , 'Y' , 'N')
    INTO   l_serial_eff_item
    FROM   mtl_system_items
   WHERE   inventory_item_id = item_id
     AND   organization_id = org_id
     AND   nvl(eam_item_type,0) = 1;

Line: 98

     SELECT NVL(eam_enabled_flag, 'N') eam_enabled_flag
     FROM   mtl_parameters
     WHERE  organization_id = p_org_id ;

Line: 131

  SELECT   'Y'
    INTO   l_asset_activity_item
    FROM   mtl_system_items
    WHERE  inventory_item_id = item_id AND
           organization_id   = org_id AND
           nvl(eam_item_type,0) = 2;

Line: 164

  SELECT   'Y'
    INTO   l_asset_group_item
    FROM   mtl_system_items
    WHERE  inventory_item_id = item_id AND
           organization_id   = org_id AND
           nvl(eam_item_type,0) = 1;

Line: 196

  SELECT   'Y'
    INTO   l_direct_item
    FROM   mtl_system_items
    WHERE  inventory_item_id = item_id AND
           organization_id   = org_id AND
           /*inventory_item_flag = 'Y' AND  Bug 7566475 Removing the and condition on the column inventory_item_flag*/
	   stock_enabled_flag = 'N';