APPS.EAM_WL_UTIL_PKG SQL Statements

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

Line: 9

      SELECT msi.description
      FROM   mtl_system_items msi, mtl_parameters mp
      WHERE  msi.inventory_item_id = p_item_id
      AND    msi.organization_id = mp.organization_id
      AND    mp.maint_organization_id = p_organization_id ;

Line: 25

	SELECT msi.concatenated_segments
	FROM   mtl_system_items_kfv msi, mtl_parameters mp
        WHERE  msi.inventory_item_id = p_item_id
        AND    msi.organization_id = mp.organization_id
        AND    mp.maint_organization_id = p_organization_id ;

Line: 43

	SELECT meaning
	FROM mfg_lookups
	WHERE lookup_code = p_lookup_code
	AND lookup_type = p_lookup_type;

Line: 60

	SELECT department_code
	FROM   bom_departments
	WHERE  organization_id = p_organization_id
        AND    department_id = p_department_id;

Line: 77

	SELECT wip_entity_name
	FROM   wip_entities
	WHERE  wip_entity_id = p_wip_entity_id;

Line: 93

	SELECT status_type
	FROM   wip_discrete_jobs
	WHERE  wip_entity_id = p_wip_entity_id;

Line: 109

	SELECT NVL(stock_enabled_flag,'N')
	FROM   mtl_system_items msi, mtl_parameters mp
	WHERE msi.inventory_item_id = p_inventory_item_id
	AND msi.organization_id = mp.organization_id
        AND    mp.maint_organization_id = p_organization_id ;

Line: 130

	SELECT cii.instance_description
	FROM   csi_item_instances cii, mtl_parameters mp
	WHERE cii.serial_number = p_serial_number
	AND cii.inventory_item_id = p_item_id
	AND cii.last_vld_organization_id = mp.organization_id
        AND mp.maint_organization_id = p_organization_id;

Line: 152

	SELECT count(*)
	FROM   wip_op_resource_instances wori,
	       wip_operation_resources wor,
	       bom_resources br
	WHERE wor.wip_entity_id = wori.wip_entity_id
        AND  wor.organization_id = wori.organization_id
        AND  wor.operation_seq_num = wori.operation_seq_num
        AND  wor.resource_seq_num = wori.resource_seq_num
        AND  br.resource_id = wor.resource_id
        AND  br.resource_type = p_resource_type		-- (1=Man)/(2=Machine)
	AND  wori.operation_seq_num  = p_operation_seq_num
	AND   wori.wip_entity_id = p_wip_entity_id
	AND wori.organization_id = p_organization_id;

Line: 178

    SELECT wip_job_number_s.nextval
      INTO l_job_sequence_number
      FROM DUAL;